-
Merge multiple Excel files into ONE WORKSHEET
Hi All:
I have multiple Excel files that has the same number of columns (with single line of data), I want to combine all those files into single "master" spreadsheet in NEW workbook. Software I am using only sends out single line data per file instead of combing everything into one file.
I tried the several VBA code but, it only seems to create new spreadsheet (tabs) in the Workbook, instead of bringing all the data into single spreadsheet.
I could take all those tabs and combine to create master list but, I don't need all those spreadsheet. Is there a better way to combine all files into single spread sheet?
thanks for your help.
Nimesh
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules