| Home |
| Search |
| Today's Posts |
|
#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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| Insert Row When Column Amount Changes | New Users to Excel | |||
| Insert New Row When Column Amount Changes | Excel Worksheet Functions | |||
| Changing the Direction of Data within a Column | Excel Worksheet Functions | |||
| How do I insert hypens in existing column representing social sec. | Excel Discussion (Misc queries) | |||
Threaded Mode
