I have an excel file that contains the manager’s name. I want to create different excel file for each manager with respective managers name in the file name. That file should contain only that manager’s data.
for e.g. below is the excel file.
Here I want to create a different excel file for each manager like “Manager1.xlsx”, “Manager2.xlsx”, “Manager3.xlsx” etc. Each excel file should only contain that manager’s data. e.g. Manager1.xlsx will contain rows specific to Manager1 and Manager2.xlsx will contain rows specific to Manager2.