Copy multiple worksheets containing tables to new workbook

[Alexis]

Hi all

I'm trying to figure out how to copy and move multiple worksheets (containing tables) to a new workbook using the macro recorder and the power of google and I'm not having much luck

I have a workbook with about 25 sheets, the majority of which are for calculations, league tables, reference tables, etc.
Each sales region needs a copy of their own filtered data (one sheet) plus a few of the other sheets.

I cannot copy a group of worksheets with tables to a new workbook, I get an error. Not sure how best to over come this.

Secondly, one worksheet has an Active X combo box. The combo box picks a sales region and tables below update (just by filtering the tables which are made up of index match or sumifs formulas). I need to be able to say, if the combo box says London then copy and move sheets x,y and z else only move sheets x and z.

I've uploaded a pretty poor example (sorry ) which has no data but kind of explains what I need to do.

For the last couple of quarters I have been copying the worksheets one by one and manually chopping out the data. This quarter I've made a super duper new model which requires far less manual work so this would be the icing on the cake

Any help much appreciated.

Regards
Alexis

 

[sn152]

Hi Alexis,

Please see the attached workbook. Let me know if this is ok.

 

[Alexis]

Hi sn152

Thanks very much for your file.

I'm not really sure it's doing what I need it to unfortunately.

Last night I was working on what I discovered was a simpler (though possibly long-winded) way of doing it, by simply copying the contents of the sheet and pasting it into a new book, then going back and forth for each sheet.

I think this method will do what I require but I will confirm once I've finished.

Thanks again for your help.

Regards,
Alexis