View Single Post
  #1   Report Post  
Dmitry Kopnichev
 
Posts: n/a
Default 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.