I am new to this forum.
I need to get Specific data from multiple xlsm files, saved in Single folder with subfolders. (Total more than 200 files)
Folder path is "E:\DATA\OPD DATA\Ped Neo"
Sheet name in each file is "PreTerm". ( It has 5 sheets, data required only from sheet "PreTerm")
Specific data required from multiple cells i.e. "A2", "A66", "A65:K65"
Data from single file to be copied in seperate row. The first column of the row should show the file name from where the data has been taken.
I am using Office 2013