2 more questions

  • Thread starter Thread starter Mauro
  • Start date Start date
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
 
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
 
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.
 
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...
 
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.
 
exactely, that is what I am looking for, a code that allows me to keep the
cells truly empty
 
Being Christmas Eve, it might pay to post to the
microsoft.public.excel.programming
Group.
 
Back
Top