When I change values in one cell conected to a different sheet, values in the same column change

Hi Irene

I've had a closer look at your table of data on sheet 1 and I see the issue.

J and K columns have circular reference issues where cells are referring to themselves instead of the previous column.

E.g. in column J (number 9 heading) formula is =[@9]*1.02 when it should be saying [@8]*1.02.

I've corrected the issues (your data remains unchanged) and the results now show on sheet 2.

I do stress that your workbook has a number of issues with the formulas you are using, but for this issue, I believe you'll see it's fixed.

Suggest you copy column J and K from the workbook I have uploaded, and paste it into your original document and see how you go?

Let me know how this goes?

Cheers
Damien