Filter Excel based on Column

How to filter excel based on Column Where Column Name is a Dynamic Data.

Get all data based on “Manager Name” Column and write it in Excel

image

Thank you in advance

  • Vincent

Hi @Vincent_Nuestro

Try to use Filter Datatable Activity.

image
image

Based on the requirement you can add multiple manager name by click (+)
image

Regards
Gokul

hi @Gokul001

The “value” in column is a dynamic data, it always change. and sometimes it is more than 5 to 10 records (“Manager Name”)

image

is there any other way to filter it out dynamically?

Hi @Vincent_Nuestro

Refer to the below thread

Regards
Gokul

Hi @Gokul001

I found same Problem here

and trying the Solution provided

I don’t know what variable type in the first Code that he provided