View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RichterCa RichterCa is offline
external usenet poster
 
Posts: 2
Default Insert rows but keep references in Excel

I use Excel to keep track of the number of calls I make for work. I have a
spreadsheet with a diferent worksheet for each month, and one at the end with
Year to Date. Since the list is the same for each month, and YTD, I tried to
just reference each one with A1 in Febuary being "=January!A1" all the way
down to A105 in Febuary being "=January!A105".

But if I get a new place to call I have to insert that row into it's proper
place in the list, which throws all my references off. Then A105 in Febuary
will change to "=January!A106". I've tried using A$105, but the same thing
still happens.

Is there any way to make those references not change when I insert rows?
I'm using Excel 2003.