Extract Sheets from Workbook

[bushmills]

Hi
I have been trying to do a simple excel macro that would extract certain sheets from a workbook and save (values and page setup only) them separately into a defined folder.

Basically:
There will be a mapping sheet that contains a list of sheetnames. Next column there will be a simple letter to denote which folder it should go under.
Ex.
A1 Sheet1 B1 P
A2 Sheet3 B2 T
C1 Sheet1 D1 T
(T) = Test
(P) = Post

Result will be 2 folders (Test and Post)
Test will have Sheet2.xls and Sheet3.xls
Post will have Sheet1.xls

Hopefully this is clear enough..

many thanks

[parttime_guy]

Hi Bushmills,

A sample workbook is attached.

What this macro does is filters Column A in the mastersheet and then copy paste values in their respective sheets.

Hope this helps.

Best Regards