Create a list of Referenced Worksheets
Closed
Joe
-
Sep 2, 2010 at 04:46 PM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Sep 3, 2010 at 06:17 PM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Sep 3, 2010 at 06:17 PM
I have a massive Excel Workbook with 200 tabs in it. One of the tabs references many of the other tabs in the workbook. I have been hunting and having a hard time finding a way to run a macro that will look in the tab I am in and create a list of all the worksheets that are pulling to that tab. For example, I have a tab named "Model" that is pulling info from many of the other worsheets in the workbook. I need to figure out in a quick way everything that is affecting the "Model" tab. Any help is greatly appreciated.
Related:
- Create a list of Referenced Worksheets
- Counter strike 1.6 cheats list - Guide
- Create skype account with gmail - Guide
- Amd crossfire gpu list - Guide
- To create a network bridge you must - Windows Forum
- Create snapchat account - Guide
1 response
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Sep 3, 2010 at 06:17 PM
Sep 3, 2010 at 06:17 PM
This isn't exactly what you need but did you know about the Ctrl ~ key? It'll toggle between values and formulas?