I received a bunch of workbooks that contain 40-80 worksheets full of data that all refer to each other. It's a mess. I would like to quickly understand what each sheet refers to. Will you please let me know what VBA code I can use to do the following: list each sheet followed by a list of other sheets it references too.
Please also include links/sources. Also many of the sheets contain over 30 columns with over 100,000 rows of data. If possible I would prefer a way to achieve this without iterating through each cell, as doing so, might take a very long time.
1: Sheet1<--- Sheet3
2: Sheet1<--- Sheet5
3: Sheet2<--- Sheet10
4: Sheet5<---Linked Sheet1: C:\Other\ExtraFiles\Backupsheet.xls
1: Says that Sheet 1 contains data from Sheet3
2: Says that Sheet 1 also contains data from Sheet 5
3: Says Sheet2 contains data from sheet 10
4: Says sheet5 contains data from sheet 1 of a linked workbook located at the following path: C:\Other\ExtraFiles\Backupsheet.xls