alkaline55
New Member
- Joined
- Jan 24, 2020
- Messages
- 28
- Office Version
- 2016
- Platform
- Windows
Hi there, hoping someone has seen something similar and knows the proper approach to this problem
I have a master workbook with 3 data tabs and 3 corresponding blank tabs. Each data tab has everyone's data by Name in the same column. I'd like to filter each of the 3 data tabs by Name, paste those values onto the 3 corresponding paste tabs, and save a copy of the workbook with the Name. I have attached an image of one data tab as an example.
The process is like this:
Filter Data1 for the first Name
Paste those values onto PASTEData1 tab
Filter Data2 for the first Name
Paste those values onto PASTEData2 tab
Filter Data3 for the first Name
Save down the workbook as Name.xlsx
Repeat for Name 2
The reference criteria could either be a Name tab with each unique name, or a loop that goes one by one finding each unique value in the column.
Thank you
I have a master workbook with 3 data tabs and 3 corresponding blank tabs. Each data tab has everyone's data by Name in the same column. I'd like to filter each of the 3 data tabs by Name, paste those values onto the 3 corresponding paste tabs, and save a copy of the workbook with the Name. I have attached an image of one data tab as an example.
The process is like this:
Filter Data1 for the first Name
Paste those values onto PASTEData1 tab
Filter Data2 for the first Name
Paste those values onto PASTEData2 tab
Filter Data3 for the first Name
Save down the workbook as Name.xlsx
Repeat for Name 2
The reference criteria could either be a Name tab with each unique name, or a loop that goes one by one finding each unique value in the column.
Thank you