Applying filter to a specific row (variable)

[Gti182]

Hi All,

I've been using below code to apply a filter to columns B:N on row 17 and then sort descending on column C.

I now need to change this to find the word "DRILLDOWN" in column B and then apply the filter to that row.
i.e. if the word "DRILLDOWN" appears in cell B25 apply filter to B25:N25 and then sort descending on C25.

Please Login or Register  to view this content.

[Parth007]

Maybe

Please Login or Register  to view this content.

[Parth007]

Please Login or Register  to view this content.

[tigeravatar]

Hello Gti182,

Something like this should work for you:

Please Login or Register  to view this content.

[Parth007]

Updated One

Please Login or Register  to view this content.

[Gti182]

thanks tigeravatar that seemed to do the trick!

Parth007 struggled to get yours to work, will test second last code

[Parth007]

Last one should work i think.. me too beginner