Hi there,
I have a workbook where cells are referenced between separate sheets on the book, by the way of =Master!F17 (where "Master" is the name of the first sheet). However, when I then move the cell F17 in the original sheet, it gets very confused in a number of ways:
first effect: It changes the formula in the secondary sheet to reflect the new Cell position of the data in the "Master" sheet eg. moving down one would change to =Master!F18
second effect: if the cell moves to a position being referenced by a separate formula on the secondary sheet, eg =Master!F18 already there, it returns an error of #REF! where Master!F18 was originally being relayed.
Is there any way of reflecting data across sheets, that is not prone to the destructive effects of moving Cells within the "master" sheet?
(the purpose of all of these fomulas is to generate visual labels for printing on the secondary sheet - therefore data from the first sheet needs to be displayed in the secondary sheet. However when editing the original sheet often requires moving cells, due to the nature of how data is organised at this company)
Thanks
Joey
Bookmarks