Hi Team,
I am trying to automate a manual activity that I does daily. I am trying to write macro to eliminate this manual activity.
I have an excel dump with lot of associates tagged under a list of projects. So each project will have so many associates tagged.
The manual activity that I do is to filter a project, copy all the content and paste it in a new excel. Then filter the 2nd project, copy the content in another new excel and move on to the next project. In this way I split the master dump based on the project id and each project details are saved in individual new excel files.
I need help in automating this by writing a macro. Based on the project id, all the details in the sheet has to be saved in new excel. So if there are 10 projects in the master dump, each project content should be saved in 10 different excel files.
Sample data attached. Please help. I am new to macros.
Bookmarks