I have (2) sheets in my workbook. I have hyperlinks in sheet #1 that is linked to a range of cells in sheet #2.
I would like to hide all cells in sheet #2 as well as the sheet itself and only make sheet #2 and specific cells visible based on the hyperlink.
Attached is my example I'm working with.
Sheet #1 have hyperlink in cell L3 & L4 that is linked to cells A2 and A22 respectively.
What I would like to happen is that when you click on hyperlink L3 in sheet #1 only rows 2-20 are visible in sheet #2. Then have another hyperlink in sheet #2 that hides the cells and sheet again and takes you back to sheet #1.
Make sense?
I would like to hide all cells in sheet #2 as well as the sheet itself and only make sheet #2 and specific cells visible based on the hyperlink.
Attached is my example I'm working with.
Sheet #1 have hyperlink in cell L3 & L4 that is linked to cells A2 and A22 respectively.
What I would like to happen is that when you click on hyperlink L3 in sheet #1 only rows 2-20 are visible in sheet #2. Then have another hyperlink in sheet #2 that hides the cells and sheet again and takes you back to sheet #1.
Make sense?