How to Save auto filtered workbook

[Sukhdev Singh]

Hi All,
Greeting for the day!
I have a workbook in which Dept. wise Data and Dept. wise summary contains in Sheet1 and Sheet2 respectively. In sheet 3 unique Dept. Name.
I wish to create a macro of auto filter of the fields contains in sheet3.
and as macro will run 5 separate workbook may be created dept. wise contain the respective data and Summary.
Need your help. Pls. help.

Sample file is attached.

thanks in advance,
Rgds,
Sukhdev Singh

 

[Hui]

Have a look at this post:
http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/

 

[Sukhdev Singh]

Hi Hui,
thanks for the reply. Actually I Need:
1. Auto filter based on the data given sheet3 (Dept). (I have Already Done)
2. Select the Data from Sheet1(Summary) & Sheet2(Data) on the basis on Sheet3(Dept). (It has also done and selecting the data using Auto Filter)
3. Now Selected Data of the Sheet1(Summary) & Sheet2(Data) may generate new workbook with the name of selected filter i.e. Dept A and data contain only Dept. A in new workbook. How can I do it.

Thanks,
Best Rgds,
Sukhdev

 

[Sukhdev Singh]

Hi Hui,
thanks for the reply. Actually I Need:
1. Auto filter based on the data given sheet3 (Dept). (I have Already Done)
2. Select the Data from Sheet1(Summary) & Sheet2(Data) on the basis on Sheet3(Dept). (It has also done and selecting the data using Auto Filter)
3. Now Selected Data of the Sheet1(Summary) & Sheet2(Data) may generate new workbook with the name of selected filter i.e. Dept A and data contain only Dept. A in new workbook. How can I do it.

Thanks,
Best Rgds,
Sukhdev

Hi All,
is there any solution of it. Kindly help.

thanks in advance.