How to change column letters to correct ones in many formulas automatically?

D

Dmitry Kopnichev

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.
 
B

Bob Phillips

Use Find & Replace? Obviously taking care that the correct order is
preserved (e.g. don't change column C to B and then B to A as the C's will
end up as A).
 
D

Dmitry Kopnichev

Thanks.
But How to automatically know how column numbers should be changes?
 
D

Dmitry Kopnichev

I can show my file. Where to send it?
Bob Phillips said:
Use Find & Replace? Obviously taking care that the correct order is
preserved (e.g. don't change column C to B and then B to A as the C's will
end up as A).
Click to expand...
 
V

vezerid

Dmitry,
could I have a copy of your file as well please?

Kostis Vezerides

vezerid at act dot edu
 
Top