If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
insert column without changing references
Hi - I have one sheet that references a range on another sheet. I want to
insert a column on the 2nd sheet and I don't want the cell references to change on the first sheet (for example A5:J5 always contains current data, when I get new data, I want to insert a new column A and have the old data get 'bumped' to column K) Bit I have tried named ranges, absolute and relative references and it always changes the formula on the first sheet. |
#3
|
|||
|
|||
Hi
Don has already provided you an answer. However, just to be clear you use indirect function like shown below =SUM(INDIRECT("Sheet2!A5:J5")) Alok "mrsmac" wrote: Hi - I have one sheet that references a range on another sheet. I want to insert a column on the 2nd sheet and I don't want the cell references to change on the first sheet (for example A5:J5 always contains current data, when I get new data, I want to insert a new column A and have the old data get 'bumped' to column K) Bit I have tried named ranges, absolute and relative references and it always changes the formula on the first sheet. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Table Autoformat --changing first column only? | bonnie | Tables | 2 | January 25th, 2005 06:09 PM |
Challenging Charting | C TO | Charts and Charting | 0 | January 17th, 2005 06:57 PM |
vlookup change column index position - without changing formulae | loopyloobyloo | Worksheet Functions | 1 | November 26th, 2004 01:35 PM |
macro to insert a formula in a column | Bryan Kelly | Charts and Charting | 1 | June 6th, 2004 11:31 PM |