Add Columns without changing calculations

Okspaghetti

New Member
Joined
Oct 26, 2011
Messages
12
I have calculations on two different worksheets refering to each other.

I need to add a column in one worksheet but when i do, the calculations on the other no longer matches. (which means i have to change every single code with the additional column.)

Is there a way to add columns to a worksheet without affecting the calculations on the other worksheet?

I hope i have explained this accuratly.
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

BigC

Well-known Member
Joined
Aug 4, 2002
Messages
851
How does this occur?
If you're using formulae which include links between the two worksheets, adding a column in one should adjust the cell references in any formula on the other worksheet accordingly!
Can expand your explanation of the problem?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,689
Messages
5,597,559
Members
414,156
Latest member
WDMix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top