Forum Discussion
Linking each cell in a workbook to show underlying data when you click on that cell.
I have several files and a lead file and on that lead file, I need to be able to click on a cell when then gives the supporting numbers in that cell or rather takes me to the right area to that infomation.
Thanks in advance
- Matt MickleBronze Contributor
The scenario you describe can be created using VBA code. If you could please provide a nonsensitive file that will give the community a little bit more context of what you're trying to do? This will help to get a more useful response.
1. Does a certain section of cells need to navigate to another section? How is this defined? Is there 5 or six scenarios? or are there 100's of them?
2. How do you define where the cursor navigates? is it a named range? or a specific worksheet you want to navigate too? Is it another file?