Filter Excel Data By Specific Criteria

[amaterano]

Hello

I think the best solution when filters become complex (multiples filters etc) is to filter based on a range of criteria.
The only condition is that the criteria range has the same titles as the data range.

In my case use the MS Excel VBO Extended, and then create a new tab with parameters



and then code




This is an example of the results, additionally the Wildcards can be used

RangeFilter: A13
RangeData: A526

 

[Shweta Naik]

Hi,

please help me to write code for excel automation using blue prism:
-In the below attached image I'm searching value with "a".
-For searched value, I'm getting similar search text results as "Arun N", "Arun P".
-how to search("a") and how to apply filter for similar search text results ("Arun N", "Arun P") in excel.

Thanks