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

--
HTH

Bob Phillips

"Dmitry Kopnichev" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
>

Thanks.
But How to automatically know how column numbers should be changes?
"Bob Phillips" <(E-Mail Removed)> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:(E-Mail Removed)...
> 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).
>
> --
> HTH
>
> Bob Phillips
>
> "Dmitry Kopnichev" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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.
> >
> >
>
>

I can show my file. Where to send it?
"Bob Phillips" <(E-Mail Removed)> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:(E-Mail Removed)...
> 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).
>
> --
> HTH
>
> Bob Phillips
>
> "Dmitry Kopnichev" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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.
> >
> >
>
>

bob dot phillips at tiscali dot co dot uk

do the obvious

--
HTH

Bob Phillips

"Dmitry Kopnichev" <(E-Mail Removed)> wrote in message
news:uykXXW%(E-Mail Removed)...
> I can show my file. Where to send it?
> "Bob Phillips" <(E-Mail Removed)> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
> ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:(E-Mail Removed)...
> > 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).
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "Dmitry Kopnichev" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > 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.
> > >
> > >
> >
> >
>
>

I have sent.
"Bob Phillips" <(E-Mail Removed)> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:uL5F%23Y%(E-Mail Removed)...
> bob dot phillips at tiscali dot co dot uk
>
> do the obvious
>
> --
> HTH
>
> Bob Phillips
>
> "Dmitry Kopnichev" <(E-Mail Removed)> wrote in message
> news:uykXXW%(E-Mail Removed)...
> > I can show my file. Where to send it?
> > "Bob Phillips" <(E-Mail Removed)> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
> > ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:(E-Mail Removed)...
> > > 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).
> > >
> > > --
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > "Dmitry Kopnichev" <(E-Mail Removed)> wrote in message
> > > news:(E-Mail Removed)...
> > > > 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.
> > > >
> > > >
> > >
> > >
> >
> >
>
>

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

Kostis Vezerides

vezerid at act dot edu

I will send in 9 hours.
"vezerid" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Dmitry,
> could I have a copy of your file as well please?
>
> Kostis Vezerides
>
> vezerid at act dot edu
>