I have a spreadsheet which runs a macro that performs a web query. The
macro copies the relevant data from the website and inserts it into a
new column on the spreadsheet - column E in this case. Thus, the old
data is shifted to column F. Now, I want column D to contain a formula
which simply calculates the difference between the new data and the
old, say =E6-F6 for the data in row 6. However even using absolute
references, when the new column is inserted, my column D formulas
change from =$E6-$F6 to =$F6-$G6.

How do I keep the formulas from changing when the new column is
inserted?

Many many thanks for any help on this one.