Consolidating workbooks tips for dating a jewish girl
Can I install this macro on workbooks that already exist and what is the proceedure for generating these into one single workbook.Thanks, Mike Mike, Once you download the macro workbook, simply open it in Excel and make sure that macros are enabled in Excel.Give this a try, and feel free to ping me back if you get stuck...thanks. -----Original Message----- From: Mike Sent: Thursday, September 01, 2011 PM To: Jeff Lenning Subject: RE: Comment for Forum topic: Macro to combine multiple workbooks into a single workbook Jeff: This macro is excellent. I'm assuming that the data on all of the 300 sheets is similar, that is, that the columns all line up etc.I wish I had something like that already built, because I'd be happy to post it up on the Free Tools area for you to download, no problem.I searched the web and found one, but it was not very useful.Also, what would be the best way to get some (entry-level) training in using the VBA editor?
The worksheets can be in the same workbook as the master worksheet or in other workbooks.To learn more about Templates, see: Create a template.This is also an ideal time to set up your template with Excel tables.Thanks Jeff Jeff, Any Idea what is the max number of files that this macro will do at once?I've tried it with approx 20, but if I close and reopen the "Merged.xls" file, it gives me a "Too many file formats" error, and then the file crashes.