Filter the data column "first name" at every sheet

hi, i am having one excel sheet ,which have data at every sheet. i want to filter by every first name in “first name” column in very sheet. and after filter write all sheet’s data to other excel file.(in short i want to make separate excel file for each one)
todayproblem.xlsx (60.6 KB)

Hi @Hemant_Deshmukh

Check out the below zip file. Hope it meets your requirement.

BlankProcess35.zip (79.8 KB)

Output 1.xlsx, Output 2.xlsx, and Output 3.xlsx are the Output excels of the present 3 sheets in the input excel.

Regards

hi, parvathy…thanks for your reply I need separate excel file john,jane,albert…in all sheets.

can you please download excel file one more time ,i had uploaded wrong one…sorry for your inconvenience.

1 Like

Sure @Hemant_Deshmukh

Give me some time. I will let you know.

Regards

Hi @Hemant_Deshmukh

Check out the below zip file. Hope it meets your requirement.

BlankProcess35.zip (130.3 KB)

Input folder contains the provided input excel file. Output folder contains the output files of each First Name.

Regards

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.