Hi all,
I have a workbook with about 30 worksheets, each with the same column headings but with a different amount of rows every month. Every month i have to consolidate each worksheet into one 'summary' worksheet (which is essentially me just copy/pasting all the rows in each worksheet under one another, without the headings)
I managed to find some VBA code online which combine all the worksheets into one, although i have a number of worksheets in my workbook which i need to exclude from the macro. I also only need the headings once at the top.
I've attached a sample workbook - so for example i need each of the worksheets combined into the 'Summary' worksheet, while excluding the tabs i don't want.
Any help is greatly appreciated!!
Thanks!!
Bookmarks