Create a list of Referenced Worksheets

Closed
Joe - 2 Sep 2010 à 16:46
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 - 3 Sep 2010 à 18:17
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:

1 response

RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 26
3 Sep 2010 à 18:17
This isn't exactly what you need but did you know about the Ctrl ~ key? It'll toggle between values and formulas?