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

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
This isn't exactly what you need but did you know about the Ctrl ~ key? It'll toggle between values and formulas?
0