Filter the data column "first name" at every sheet

Help Activities
, ,
1

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)

image
image852×863 27.8 KB

2

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

3

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
4

Sure @Hemant_Deshmukh

Give me some time. I will let you know.

Regards

5

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

6

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