Thanks a lot Jerry. That was exactly what I was after. I forgot to write
back and thank you, but I corrected the sheet and it works perfectly. It was
for a big company and all the employees are used to adding this weeks sales
to the end of the tables and then deleting the first row so that the sales
charts are always the same length. I was making a table at the bottom which
shows various statistics but like I said when the first row is deleted it
changes the locations and the whole thing gets messed up. Not any more.
Cheers
Pete


"Jerry W. Lewis" wrote:

Gordon wrote:


Why not just use $I$4 ?

If =$I$4 is in A1 and you delete column H, then the formula in A1 will
now read $H$4, where the OP wanted it to refer to the new I4 cell.

Jerry