Create a new workbook and copy the filtered data to the workbook created .

[knspradeep]

Hi All,

I have a data sheet with various project Managers names nearly 100 project managers.I want to write a VBA code to filter the data for each project manager and create a new workbook and copy the related data of the project manager to the created work book.And please make a note that the project managers names can be duplicate.

 

[sijpie]

So which other field is important in filtering the table?

Try recording a macro, where you filter the data on the required fields and then copy the results into a new workbook.

 

[sijpie]

-duplicate-