Sep 2, 2010 at 04:46 PM
Posts122Registration dateTuesday August 31, 2010StatusContributorLast seenJune 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.