Copying data from multiple file into one file

  • Thread starter Thread starter nsd
  • Start date Start date
N

nsd

Hello,

I have around 150 files having same Column headings and around 200 records
under rows.

I want to creat one big file to have all the records from these 150 files.
Is there a easy way to do that ?

Please advise and thanks for help.
Dinesh
 
Thank you so very much. It saved me big time.

I have a quick question though. The file generates 2 sheets namely "Combine
Sheet and "Log Sheet". Do i need to keep it that way or I can delete the log
sheet and the Column A of Combine sheet, as it has the name/location of files.

Please advise. And thanks once again.
Dinesh
 
Back
Top