Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to change column letters to correct ones in many formulas automatically?
Hello
I have to make a 2004 year calculation using 2004 year table in the same way a 2003 year calculation which used 2003 year table was made. I copied formulas from 2003 version table to 2004 version table. The 2004 version table has different columns order therefore column letters in the formulas are incorrect. I want to change the column letters to correct ones according to 2003 and 2004 column lables located in a top rows in the tables. I have to use columns with the same lables as in 2003 year in formulas. How to change the column letters to correct ones in all formulas automatically? I do not need to change row numbers because they are correct. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Copy a column in worksheet with a character change | Excel Worksheet Functions | |||
Excel column headings from numbers to letters | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel |