Adding columns within a set of formulas

[Guest]

I have columns A thru D that receive calculations into them depending on formulas placed into columns AA thru DD. AA1 puts a number into A1, BB1 into B1, etc. If I insert a column between columns A & B, the corresponding column between AA & BB doesn't not automatically get created and all my formula links are thrown off. Is there a workaround to this

Thanx!

 

[Peo Sjoblom]

Frankly I have a hard time understanding what you mean,
if you are saying that A1 holds =AA1 and B1 =BB1
and if you insert a new column between A and B and B1
changes, then you can use

=INDIRECT("AB1")

there are 26 columns between AA1 and BB1


--

Regards,

Peo Sjoblom

I have columns A thru D that receive calculations into them depending on

formulas placed into columns AA thru DD. AA1 puts a number into A1, BB1
into B1, etc. If I insert a column between columns A & B, the corresponding
column between AA & BB doesn't not automatically get created and all my
formula links are thrown off. Is there a workaround to this?

 

[Guest]

Sorry, I didn't mean cell BB1, I meant AB1.

 

[Guest]

Thanks Peo, this may be my answer!!