Hi
I have a workbook with a list of values in column A
Example
112.33
443.22
116.44
then i have a folder, with 5 workbooks within, with multiple sheets ( up to 100 )
them values above will be somewhere on a sheet in the above workbooks, what i need is to loop / open each workbook
find that value, then list the sheet name and file name in column B/C on my original workbook next value im looking for
many thanks in advance!
Bookmarks