Hi I am looking to create a formula or "event" where when a Cell is clicked it takes you to another area of a different sheet for further information, I know this can be done with a simple hyperlink but due to the sensitivity of the material I need something additional to happen. Basically I want to be able to click on cell A1 in sheet 1, that would then take me to a section in sheet 2 where there is more information, but I only want to see the information that pertains to cell A1 Sheet 1. There will be data in a lot of cells in column A so there will be a lot of info on Sheet 2.
Essentially
Essentially
- Click on cell A1 in Sheet 1
- Takes you to Sheet 2
- "Hides" all information on sheet 2 except A1, B1,C1, and D1
- Go back to Sheet 1
- Click on cell A2 in Sheet 1
- Takes you to Sheet 2
- "Hides" all information on sheet 2 except, A2, B2, C2, and D2