|
|
Empty Rows and Columns by
fak119
Is there a Macro (or how does one create one) that eliminates automatically
empty rows and columns?
|
April 5th, 2006 12:39 PM
by CLR
|
1 |
128 |
|
|
Excell budget worksheets by
F_disk
Newb here....needing some help...
I am using 4 work sheets to represent the four weeks in a month.
I want to be able to put say "dog food" in B23 on all four...
|
April 5th, 2006 11:04 AM
by F_disk
|
2 |
127 |
|
|
End of range changes when I add a number by
Julian
Please could someone explain why Excel 2000 changes the range in
another cell when I type a number into a blank cell?
I have a spreadsheet that calculates...
|
April 5th, 2006 09:04 AM
by Julian
|
1 |
108 |
|
|
Automatic Deletion of Rows by
ai18ma
Dear Experts,
I wish to :
1. Select columns containing a certain value ( here 0)
2. Then delete the ROWs with that valie automatically.
I found the command...
|
April 5th, 2006 08:25 AM
by x10sion
|
6 |
255 |
|
|
Target Question by
jkrist46
Below is the Macro I have. Instead of doing a copy of entire row I want
just certain cells in that row (A-H). What would be the best way to
accomplish...
|
|
1 |
176 |
|
|
Adding cells proplem by
r
i had a cell (C1) called "total" that displays the sum of two other cells..
i.e. the total cell got the formula "=sum(A1+B1)" ..
I then typed a value in cell...
|
April 5th, 2006 04:14 AM
by r
|
2 |
173 |
|
|
converter by
recipe type data
what do i need to do to convert quattro pro 5.0 files over to excel 2000.
|
April 5th, 2006 01:16 AM
by Pete_UK
|
4 |
149 |
|
|
|
April 5th, 2006 12:14 AM
by Pete_UK
|
1 |
221 |
|
|
Cumulative Average on a worksheet by
Daryl
Can someone give me direction on what I need to do? We recently began
keeping attendance during church worship services at our church and I have
created a...
|
April 5th, 2006 12:12 AM
by Pete_UK
|
1 |
173 |
|
|
|
|
3 |
157 |
|
|
Target Question by
jkrist46
Below is the Macro I have. Instead of doing a copy of entire row I want
just certain cells in that row (A-H). What would be the best way to
accomplish...
|
|
2 |
122 |
|
|
|
|
3 |
179 |
|
|
excel cell text input by
jnieurzyla
I use excell to build a batebase up, and I wish in certain columns to have
the first character to be in uppercase, how do I do that?
I am a newbie.
Thank you
|
April 4th, 2006 05:50 PM
by CLR
|
1 |
121 |
|
|
sum using or (if Blank cell in Column) by
Dreadhead
My Basic problem seems to be that i cannot run a variable against a blank cell.
My set up as below:
Item 50cl 70cl 1.5cl per 25ml ( answer i'm...
|
|
0 |
101 |
|
|
|
April 4th, 2006 08:54 AM
by ScottO
|
1 |
127 |
|
|
|
|
3 |
162 |
|
|
sorting data, formula contance by
jeff
When I sort a group of cells by highest number to lowest one column changes
the formula to match where the cell moves to. So if cell J9 moves to cell J8
in...
|
|
2 |
122 |
|
|
|
|
8 |
140 |
|
|
Counta by
martins
I am using COUNTA to count data in a range of cells - the data in this
instance is dates formatted as say Jan-06 - should work ok except that
the formula is...
|
April 4th, 2006 12:04 AM
by Max
|
2 |
110 |
|
|
Changing the Excel color palette by
Don McClure
I want to be able to set the RGB value for a fill color in a macro. The
color palette does not have the soft pastels I want to use. The problem
stems from the...
|
|
2 |
131 |