gkisystems
Board Regular
- Joined
- Apr 20, 2012
- Messages
- 76
I have a very large tab within Excel that I want to create hyperlinks saying "click here to go to this section of this tab." The problem I have is that each day, this tab gets copied daily and renamed with the new date, so on the copied tab, the hyperlink takes you back to the older tab because my hyperlinks reference both a cell AND a worksheet.
How do I create a hyperlink that only references cells within the active worksheet?
How do I create a hyperlink that only references cells within the active worksheet?
