asudevils5150
New Member
- Joined
- Feb 19, 2002
- Messages
- 49
Is there a macro to conslidate let's say 3 workbooks into one workbook. Also, let's assume the each workbook has 5 sheets within each book. I'd like to have the new workbook have each sheet separately. Then I have a macro to combine each sheet into one sheet. Ultimately, I'd like to consolidate each worksheet from various workbooks into one master sheet (within a new workbook).
Any help is greatly appreciated
Any help is greatly appreciated