Excel warriors,
I have 38 xlsx files stored in one folder. Each file has a different count of sheets (15+)—all sheets have the same column count, same headings, but different counts of rows. I need a macro to append (consolidate) all of the sheets into one sheet in a new workbook. This consolidated workbook must have only one heading and the same format as the original sheet's cells, like the cell's background colors, font format, column width, row height, or alignment/wrap text. The users of these 38x15+ sheets have made "random" format modifications in cells (cells anywhere within the workbooks have user format modification), so these changes MUST remain in the consolidated one-sheet workbook. I know a consolidated workbook can be done using the Power Query feature Get and Transform, but the resulting consolidated sheet will lose the original cell's format.
Can somebody point out a macro VBA solution?
Thanks for your help!
I have 38 xlsx files stored in one folder. Each file has a different count of sheets (15+)—all sheets have the same column count, same headings, but different counts of rows. I need a macro to append (consolidate) all of the sheets into one sheet in a new workbook. This consolidated workbook must have only one heading and the same format as the original sheet's cells, like the cell's background colors, font format, column width, row height, or alignment/wrap text. The users of these 38x15+ sheets have made "random" format modifications in cells (cells anywhere within the workbooks have user format modification), so these changes MUST remain in the consolidated one-sheet workbook. I know a consolidated workbook can be done using the Power Query feature Get and Transform, but the resulting consolidated sheet will lose the original cell's format.
Can somebody point out a macro VBA solution?
Thanks for your help!
