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.
They need to retain the tab names in the master workbook.
Microsoft ExcelVB ScriptC++VBA
Last Comment
K B
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
The above routine should be run from the Master workbook, which should be saved in the same location as the workbooks to consolidate.
ASKER
Thank you very much!! I have one more out there fairly similar
https://www.experts-exchange.com/questions/28660327/Excel-Workbooks-with-single-tabs-consolidate-columns-A-D-into-one-long-column-in-a-workbook.html
also you helped me on https://www.experts-exchange.com/questions/28656054/Create-multiple-CSV-files-from-one-Excel-file.html
and it errored out. So close to finishing...it createds CSVs but hit a error.
Wayne as always thank you for your knowledge!
https://www.experts-exchange.com/questions/28660327/Excel-Workbooks-with-single-tabs-consolidate-columns-A-D-into-one-long-column-in-a-workbook.html
also you helped me on https://www.experts-exchange.com/questions/28656054/Create-multiple-CSV-files-from-one-Excel-file.html
and it errored out. So close to finishing...it createds CSVs but hit a error.
Wayne as always thank you for your knowledge!