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

  • Thread starter Thread starter Dmitry Kopnichev
  • Start date Start date
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.
 
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).
 
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...
 
Dmitry,
could I have a copy of your file as well please?

Kostis Vezerides

vezerid at act dot edu
 
Back
Top