Thread: Moving Formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
benjam_in benjam_in is offline
external usenet poster
 
Posts: 1
Default Moving Formulas


I have a sheet that contains a number of formulas, every day the sheet
is copied, labeled as todays and the data removed, today data put in.
The amount of rows in the data inserted varies from day to day. Ive go
a number of formulas analysing the data inputted to the sheet that get
shifted when the old data is removed and the new data input. Does
anyone know a way of making the formulas entered in excel stay as they
were no matter what.

Hope someone can help as this is driving me nuts!!

Ben


--
benjam_in
------------------------------------------------------------------------
benjam_in's Profile: http://www.excelforum.com/member.php...o&userid=36295
View this thread: http://www.excelforum.com/showthread...hreadid=567769