Copy formula automatically down when date is entered
Hi
is a bit messy when printing.
Presumably, you mean because the sheet shows a series of errors where
there are no entries in column B.
Amend your formula in C5 to
=IF(B5="","", your_formula )
and copy down as far as required.
Nothing with show in column C until entries are made in the
corresponding cell of column B
--
Regards
Roger Govier
"tommylux" wrote in message
oups.com...
I would like to apply a formula to the entire column, but this
increases the size of the spreadsheet and also is a bit messy when
printing.
When I enter data into B5 for example, I would like C5 to
automatically
enter the vlookup formula I have written.
Any Visual basic commands I could try?
Thanks again guys for your help
|