R
RichterCa
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.
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.