November 13, 2021
Hi, I have what I think is a simple problem, but I have been trying for days to solve it, to no avail.
I have a series of sheets that are all identical in that they are calculators to estimate building work
When a calculation is done, I copy the description and price onto a master sheet. The price cell links to A1 on its own sheet so that when I paste it into the master sheet I am able to click on the price and it will return me to the appropriate calculation sheet
The problem arises when I duplicate the calculator sheet. On the new sheet, the link to A1 works fine, but when pasted into a master sheet, the link takes me back to the sheet I used to make the duplicate from, rather than the duplicated sheet itself.
I have made a very simple 3 sheet workbook to better explain which is attached
Any help appreciated
July 16, 2010
Welcome to our forum! It looks like cell names with workbook scope trump names with worksheet scope even though the hyperlink definition on sheet3 is to go to sheet2.
Perhaps you can use a HYPERLINK formula instead as this seems to jump to the correctly defined location.