Hi,
I have a huge data, where I would like to filter the data using the header "Project Leader" and select the first Project leader and move or copy the data to new work book and delete the data of all other project leaders and name the new work book with the Project leader name and save in a particular location and then close the work book and come back to the original work book and now select the second Project leader form the filter and continue the same above process and it should continue for all the project leaders we have in this sheet.
Please help me in doing this using macro..
I have a huge data, where I would like to filter the data using the header "Project Leader" and select the first Project leader and move or copy the data to new work book and delete the data of all other project leaders and name the new work book with the Project leader name and save in a particular location and then close the work book and come back to the original work book and now select the second Project leader form the filter and continue the same above process and it should continue for all the project leaders we have in this sheet.
Please help me in doing this using macro..