Copy certain items

[Keith Crooks]

Hi Guys,

I have a spreadsheet that is basically a time sheet,
I have to put a customer name and number into
cell D24 to D59 and a quantity of hours into U24 to D59
monday covers D24 to D28
Tuesday covers D29 to D32
etc.
The same for the time

I then have to further down the sheet repeat this information in I93
toI20(ish)

my problem is that
A, I dont want to have to manually type in the same info twice
B, I may only do one job a day so I'm left with 3 blank cells before I start
tuesday, what i need to do is to have the info repeated from cell d24 into
I93 but I94 could need to contain data from one of the following cells d25,
d26, d27,d28 or d29, depends on how many jobs i do.


many thanks in advance, hope this is clear..

keith

 

[grayco]

Hello Keith,

The basic formula to make a cell (I93) contain what another cell
(D24)contains is
"=D24". This would be put in I93.

To keep "=D24" from changing to "=D25" or "=E24" when you drag it into
multiple cells, add dollar signs to it. "=$D$24" the "$" in front of
the "D" cement the "D" and the $ in front of the "24" cements it.

To keep a cell with a formula from having an answer in it, you have to
give it a test.
Here's a example;

"=IF(D24=0, "", A1)
This reads, If cell D24 equals 0 (coma) fill this cell with double
quote marks (coma) If it's not equal to 0 then fill this cell with the
value found in cell A1.

Double quote marks leave a cell blank with no value.

Good Luck