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
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