Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a key to insert rows in excel? | Excel Discussion (Misc queries) | |||
how do i insert references (footnotes, endnotes) in ms excel? | Excel Discussion (Misc queries) | |||
Insert row without adjusting references | Excel Discussion (Misc queries) | |||
how do i insert references (footnotes, endnotes) in ms excel? | Excel Discussion (Misc queries) | |||
insert column without changing references | Excel Worksheet Functions |