LinkBack URL
About LinkBacks
Is there a fast easy way to merge 300 small spreadsheets into 1? They are formatted the same with only four columns. Three of them are attached. Thanks. Joe
Is there a fast easy way to merge 300 small spreadsheets into 1? They are formatted the same with only four columns. Three of them are attached. Thanks. Joe
Do you have experience with Visual Basic for Application (VBA)? The easiest way probably would be write a macro to loop each single file.
Hello there,
Do you want them to appear on one worksheet or on 300 individual worksheets?
Thanks,
RVASQUEZ
One worksheet. There are 300 that I want to merge into one, four-column worksheet. Thanks. (Excel 2003 by the way)
Thank you JieJenn - I don't know how to do that, though.
-Joe
Last edited by joebird; 05-10-2012 at 01:16 PM. Reason: sp
Create a workbook and named it Master Table. Press ALT + F11 to open the VBA window, right click ThisWorkbook, Insert, Module, and copy and paste the code.
Move all the files within the same folder. Under View ribbon, click Macro and click LoopFiles and click run. You might need to manually enter the header as I am at work, so I am trying to do as minimum as possible. But I just tested the macro, it loops all the file data into one master worksheet for me. Oh, you also need to change the directory address.
Please Login or Register to view this content.
Got it! Thanks. I'll give it a shot.
Let me know if it works.
It works!!! Thank you ever so much. (It was 382 files).
-Joe
I guess it worked?
Cool. Now I get to brag about during the team meeting today haha...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks