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 infom...
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?