Macro that detects the source files and lists all the formulas

Hi,

I am trying to write a macro that identifies the cells that use one of the source files, and then copy and paste the formulas in a column.

For example, let's say I have two files "File1.xlsx" and "File2.xlsx"
In File1.xlsx, the formulas in cell A3 is "[File2.xlsx]Shee1!A3"
I want to write a macro that detects all cells that refer to the file File2.xlsx and then provides their formulas. So, one of my outputs would show "[File2.xlsx]Shee1!A3"

Thanks!

Hi

This may give you some direction.

Please Login or Register  to view this content.

rylo