Link to home
Start Free TrialLog in
Avatar of K B
K BFlag for United States of America

asked on

Consolidate Excel workbooks into a single workbook

They all live in the same folder and really just have one tab each.
They need to retain the tab names in the master workbook.
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The above routine should be run from the Master workbook, which should be saved in the same location as the workbooks to consolidate.
Avatar of K B


Thank you very much!! I have one more out there fairly similar

also you helped me on
and it errored out.   So close to createds CSVs but hit a error.

Wayne as always thank you for your knowledge!