I just wanted to find the way to solve the below problem using VBA.
I have 100+workbook where cross reference to other workpapers are given in red colour. I need to extract all of them in to one master list. Is it possible.
Source files are in work and excel.