Hello,
I am a beginner to excel and have a workbook with 2 pages. The first page is an overview of the second page. The workbook is a matrix of the laws in all 50 states regarding various topics. I want each cell on the first sheet to hyperlink to its corresponding cell on the second sheet - in other words, I want A1 on first page to link to A1 on second page, A2 to A2 on second page, A3 to A3, B1 to B1, B2 to B2 and so on. I have attached a small sample sheet with the hyperlinks between the sheets included. Until now I have done it manually by doing control k for each cell and putting in the specific destination on the second sheet that I wanted it to hyperlink to, but I want it to be able to be done automatically since I have over 1000 cells. I am concerned with the hyperlinks between the two sheets, not the hyperlinks on the second sheet that link cells on the second sheet to other online locations.
Bookmarks