Copy formula automatically down when date is entered
Hi Kassie
I think this only works in XL2003 (and presumably 2007) and only if you
have created a List with DataList.
--
Regards
Roger Govier
"kassie" wrote in message
...
Click on Tools|Options, select the Edit tab, and make sure that Extend
List
formats and Formulas is ticked. As you go down, this will
automatically
extend your formulas
"tommylux" wrote:
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
|