Create a list of Referenced Worksheets [Closed]

Report
-
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
-
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 reply

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
This isn't exactly what you need but did you know about the Ctrl ~ key? It'll toggle between values and formulas?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!