I have a folder at this location
D:\AAtif data\D drive\TEST DATA FOLDER\New folder
This folder contains many files.
In each file there is "sheet1" & "Sheet2", which contain data from cells A4 : D30
I need to prepare a summary. VBA Code should open files and prepare a summary sheet, compling data from all files.
One colums of the summary should show Name of the source file for easy tracking.
Thanks
D:\AAtif data\D drive\TEST DATA FOLDER\New folder
This folder contains many files.
In each file there is "sheet1" & "Sheet2", which contain data from cells A4 : D30
I need to prepare a summary. VBA Code should open files and prepare a summary sheet, compling data from all files.
One colums of the summary should show Name of the source file for easy tracking.
Thanks