Jacelyn Lok
New Member
- Joined
- Aug 17, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi all,
I am new to VBA and I wish to complete task below in one Macro script. Will need you all help here.
1) Filter the Source file with Unique value tab
2) Copy the selected filtered column value and paste to the designated Destination file
3) Save the Destination file name as "Project Name" (this file is designated with only column name and blank content)
4) Continue loop for the next unique value and repeat from step 1) to 3).
I have tried a few code but it seems not working for my task.
Attached my sample "Source" and "Destination" workbook file.
Thanks.
I am new to VBA and I wish to complete task below in one Macro script. Will need you all help here.
1) Filter the Source file with Unique value tab
2) Copy the selected filtered column value and paste to the designated Destination file
3) Save the Destination file name as "Project Name" (this file is designated with only column name and blank content)
4) Continue loop for the next unique value and repeat from step 1) to 3).
I have tried a few code but it seems not working for my task.
Attached my sample "Source" and "Destination" workbook file.
Thanks.