| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Maintain Relative Reference After Inserting a Column
A B
1 +A1 2 If column B1 has the formula +A1 in it, and I insert a colum between columnn A and B, C1 then has the formula +A1 in it as a result of the column insert. A B C 1 +A1 2 How do I construct the original formula in B1 (+A1) so that when a column is inserted between columns A and B, which moves the formula over to column C as a result of the column insert, the formula in C1 references the cell next to it as +B1 rather than still showing +A1 as the formula? I want the formula to always reference the cell immediately next to itself without being affected by column inserts. I know there is probably a simple answer but I can't figure it out. Any help is appreciated. Thanks, -Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to use the INDIRECT funtion with a relative Row reference | Excel Discussion (Misc queries) | |||
| Sort as "reference column" | Excel Discussion (Misc queries) | |||
| Macro to change Chart Range when inserting a column | Charts and Charting in Excel | |||
| return cell reference from any column | Excel Worksheet Functions | |||
| reference cell value from fixed column with variable row | Excel Discussion (Misc queries) | |||
Threaded Mode
