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.

Insert rows but keep references in Excel
 

Hi,

use indirect

=INDIRECT("January!A1")

Mike

"RichterCa" wrote:

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.

Insert rows but keep references in Excel
 

Thanks, that was a big help. It's not perfect, but I'm getting closer.

"Mike H" wrote:

Hi,

use indirect

=INDIRECT("January!A1")

Mike