|
|
Excel VBA-Geting data from Access by
kodricales
My problem is that I don't know how to connect to an Access database
from Excel. I'm modifying a macro in which I have to compare some
strings in Excel cells...
|
|
2 |
904 |
|
|
Save as Web Page in Excel 2002 by
Bob
Is there any way to "tone down" the code that Excel 2002
creates when saving a worksheet as a web page? We
converted to Excel 2002 this past year at work and...
|
June 23rd, 2004 02:49 PM
by Brad
|
1 |
902 |
|
|
|
|
6 |
902 |
|
|
Excel 2007 Pivot Tables by
Marsh
1. How can I create a Pivot Table from a text file, downloaded from a
mainframe database? I have been told this could be done in previous versions
of...
|
|
1 |
900 |
|
|
Find & Replace in XP by
Jane
XP now has the ability to do a find & replace based on
formatting, but i ran across an issue. If I type the word
accountant in cell A1 and "accountants are...
|
|
3 |
899 |
|
|
Finding maximum value by
Ruan
Hello,
I want to find the maximum value in a column, but I want to ignore the
negative and positive part of the value. Basically, the maximum difference
from...
|
|
3 |
898 |
|
|
search for a string by
santana
How can I search for a string (“Draft Documents”) in sheet1 and then delete
all the rows above the row containing the string and then delete the last two...
|
|
1 |
897 |
|
|
e Mail attachment by
La Blonde
I received an attachment recently, which, when I opened it, appeared as
gobbledegook- I have Windows xp and Offfice 2000 & it seems the attachment
was...
|
|
3 |
896 |
|
|
=if formulae by
Janie
I have and excel spreadsheet which I wish to record an error message if one
cell as a value of more than zero and the cell below it has a value of zero.
I...
|
|
2 |
894 |
|
|
New To Formulas - Help please by
kirstikate
This is probably very easy, but im having trouble - I want to find a formula
that does the following
IF H49 + G49 = F49 and F49=I49 then True If it...
|
May 25th, 2010 09:05 PM
by Brad
|
6 |
894 |
|
|
|
|
1 |
894 |
|
|
No zoom to page option ??? by
Blue Max
Doesn't Excel 2007 have an option to quickly zoom to the full page, the
width, or the height?
Most current programs provide quick menu options or toolbar...
|
|
5 |
894 |
|
|
|
|
3 |
894 |
|
|
Resetting cells to zero value. by
Ron
I have lots of cells with numbers. Can I place a button that will reset all
cells to zero?
Right now, when I want to start over, I go to each cell and change...
|
|
4 |
894 |
|
|
formula for copy and paste by
robbie5
can i create a condtional function in a cell that would send data in one row
of cells to a cell in another worksheet.
ex
a1
a2= aaaa
a3= bbbb
a4=cccc
a5=if a1...
|
December 27th, 2005 09:59 PM
by bpeltzer
|
2 |
894 |
|
|
|
|
3 |
891 |
|
|
|
|
0 |
891 |
|
|
Comparing, Matching, and Sum formula by
ma
Hello.
Column A has dates. The format is 2010-04-29. There are multiple rows with
the same date.
Column B has numbers
Please, provide me the formula IF:...
|
|
6 |
887 |
|
|
Header by
Belin
I am new to this Excel 2007 and don't know how to put a title where the
lettered columns are. I need it to be centered across 4 columns. Thanks for
the help
|
|
1 |
887 |
|
|
Salary Reciept by
hikmat
I need to make a Salary Reciept for my office use, i have staff here and i
have to pay them. i need a strong Salary Reciept, so i can pay staff salary
and...
|
|
3 |
886 |