Forum Discussion
Copying sheets with internal links
mathetes Thank you for the response!
In terms of references, when I created the excel sheet, I only referenced A1 not Sheet1!A1. However, when I copy the sheet, the reference changes from A1 to Sheet1!A1. Would it be more efficient to reference $A$1? Please note that these references are hyper links, they are being used to jump from one side of page to another as it is a rather large amount of data.
To answer you questions I am doing a semester long breakdown, and I was hoping to create a template that could then be duplicated for every week needed. The sheet has multiple internal links, but no links that go outside of that one individual sheet.
Hope this answered your questions!
Oh my. I have no experience using references like that as hyperlinks. Happy to learn, but that puts your inquiry into a different ball park.
Is it possible for you to post a copy of the workbook on OneDrive or GoogleDrive, and post a link here so that I and others can actually take a look at it?