PDA

View Full Version : Need to filter data and create new workbooks



Happy173
10-09-2017, 02:21 AM
Hi All


I really need your help for the below project


Problem : Need to filter data and create new workbooks


Steps:
1. Filter all the unique values in Column C (i.e. Headings) an copy paste each unique item(i.e. Alphabets, Numbers, Fruits and Vegetables) in new workbooks.(These workbooks are master files)
2. When each unique item(i.e. Alphabets, Numbers, Fruits and Vegetables) is copied to the master file, even the pivot sheets should be copied along with it (i.e Pivot1, Pivot2, Pivot3, Pivot4, Pivot5, Pivot6)
3. Once the above step is done, select a master file (eg : Alphabets) and filter the H column (i.e. Items) and copy paste each unique item(i.e A, B, C, D) in new workbooks (These workbooks are sub files)
4. When each unique item(i.e A, B, C, D) is copied to the sub file, even the pivot sheets should be copied along with it (i.e Pivot1, Pivot2, Pivot3,)
5.Step 3 & 4, should repeat for all other Master files (i.e Numbers, Fruits, Vegetables)

Can someone please help

Thank You

p45cal
10-09-2017, 02:33 AM
…and at what time would Sir like dinner to be served?

Happy173
10-09-2017, 03:07 AM
…and at what time would Sir like dinner to be served?

Sorry???

mdmackillop
10-09-2017, 03:29 AM
This site is not a free coding service. If you wish code to be written for you, please contact our Consulting Services (http://www.vbaexpress.com/contact.htm)

snb
10-09-2017, 03:43 AM
Nor is it a school assignment solver service.....