Thread: How to set up worksheet where cells change monthly
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robina Robina is offline
external usenet poster
  
Posts: 3
Default How to set up worksheet where cells change monthly
I have an excel spreadsheet where each month the cell location changes - i.e.
SUM(C56:C79) = January is changed to SUM(C57:C79) in February. Each month it
increments down. I have to repeat this formula 120 times, with each one a
different amount. Is there any way to code this into Excel so that I don't
need to change each cell every month?
Reply With QuoteReply With Quote