True Absolute Reference

F

f252863

Hi,

When I insert columns I have to redo all my formulas. I understand
you can use indirect but I don't think it will work.

My formula is a simple =$E$20-$G$20, when I insert two columns it
becomes =$G$20-$I$20. How do I force it to keep the original cell
addresses?

Many thanks!
 
F

f252863

THANK YOU!!!! Just cut down processing changes from 20 minutes to 2,
now I'm working on getting it down to 20 seconds.
 
Top