View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aerynd Aerynd is offline
external usenet poster
 
Posts: 1
Default How can I keep a formula to specific column in excel?

I'm trying to work with a rolling 12 month period, with calculations at the
end of the last month. But when I delete the oldest month all my calculations
disappear!
How can I get the worksheet to attribute the formula to columns so that when
I delete a set of columns (and they are replaced with a similar set; as
everything is moved back one set) the formula still works?
HELP!