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.

try using indirect

--
Don Guillett
SalesAid Software

"mrsmac" wrote in message
...
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.

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.