Forum Discussion
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
Hi Damien,
When I look at the second sheet, there is #REF! error in the cells K15 and L15 although it shouldn't be.
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
Dear Damien, thank you for your help. I have copied the columns and the table is ok now. I need to pay more attention to the formulas!
Thank you for your support! Best regards.
Irene
- Happy to help, Irene. If you could please mark the solution as best response, that will allow other visitors to learn of how to resolve these sorts of things.
All the best!
Cheers
Damien