2 more questions

M

Mauro

First of all thanks to all of you who helped me with my workbook.
I have 2 more questions to ask:

1. cell F2 has a SUM formula. I would like the formula to go automatically
to F3 but this ONLY if A3 is not empty and to F4 if A4 is not empty and so
on. Is it possible?

2. at the end of the day all data inserted in Sheet 1 go automatically to a
hidden sheet and is deleted from sheet 1. is it possible to create a macro
or whatever which can restore the SUM formula in F2 etc (as above)?

Thanks again for your help
 
M

Mauro

Hello Ragdyer,
I don't know how many times I need the formula, that's why I need it to be
copied automatically if cell A (of the row) is not empty
 
R

Ragdyer

You could copy it down to Row 1000 if you wished, since *nothing* will
display in Column F as long as the corresponding Column A cell is empty.
 
M

Mauro

by doing so the sheet would become very big, I've tried that solution
already. The problem is that I don't know how many cells I would need... it
could be 1000 or 50000...
 
R

Ragdyer

I'm sorry, but I don't understand your concern.

You could simply and easily and quickly just drag down to copy as many or as
few of the formulas as you might need for any specific time period.

A formula can *only* "control" the cell that it populates.
It cannot "send" anything to another cell.

If you wish for a cell to remain truly *empty* until another cell is used,
you'll have to use code.
 
M

Mauro

exactely, that is what I am looking for, a code that allows me to keep the
cells truly empty
 
R

Ragdyer

Being Christmas Eve, it might pay to post to the
microsoft.public.excel.programming
Group.
 
Top