How to update formula in cloumn automatically?

[spmorin]

I have a simple forumal in one column that works. I need to have the formaul update to all rows that are added when I update the data from and external source. Usaually 100 or so rows added each update?

[Richard Buttrey]

Hi,

The usual way would be to have a small VBA macro to do this. The approach I generally use is to ensure there are a few spare rows above the data and keep a copy of the formula in Row 1. Let's say it's in E1. Name the cell E1 'MyFormula', then create a macro as follows:

Please Login or Register  to view this content.

This assumes that new records always have a value of some sort in column A.

[spmorin]

Thanks, worked nicely.