There are around 200 excel files in a folder eg D:\test and all the excel file have a sheet and every sheet are of same format only different is the content of the excel file. I need to create a summary excel which contain all the required info from the 200 excel file. i am confused how to solve this?
for eg
the header1 is in A3 and its value in A4
header 2 in A5 and its value in A6
header3 in B6 and its value in D8 and so on
i need to copy the header and value in new excel sheet.
how to solve this?
Please help me to solve this..
Bookmarks