Balajibenz
Board Regular
- Joined
- Nov 18, 2020
- Messages
- 80
- Office Version
- 2013
- Platform
- Windows
Hi, Can you someone help me with below requirement.
I have a worksheet with data until column Z. I have list of names as below in the column "AD"(strating from AD1) of same worksheet.
I am trying to have a VBA code that loops through the list in "AD" and filter the name in Column "Z" and copy the data and create a new workbook and paste the data. this new workbook should be named as the filtered name and should be saved in same path as activeworkbook. this needs to be repated untill last value in column "AD".
in this case we should have 5 different workbooks saved in the same path as active workbook with the above names.
I have a worksheet with data until column Z. I have list of names as below in the column "AD"(strating from AD1) of same worksheet.
| Max |
| Alex |
| Harry |
| Sam |
| Sid |
I am trying to have a VBA code that loops through the list in "AD" and filter the name in Column "Z" and copy the data and create a new workbook and paste the data. this new workbook should be named as the filtered name and should be saved in same path as activeworkbook. this needs to be repated untill last value in column "AD".
in this case we should have 5 different workbooks saved in the same path as active workbook with the above names.
