Filtering multiple columns at once

[Pasty]

Hi there,

I have a number of processes in columns N:U and some are filled in and some aren't for example it could look like this:

Process 1 Process 2 Process 3
Process 2 Process 4 Process 6
Process 1 Process 3 Process 4

There are 40 processes and they when chosen they will sit in order across the columns but a different combination and amount of each process can exist for each row.

What I am trying to do is filter them. So for example if I look for process 1 in columns N:U it will show the 1st and 3rd row.

I have tried this piece of code but it doesn't seem to work and finds nothing even if the process is there.

filterCriteria = InputBox("Please enter what process you're searching for")
Application.ScreenUpdating = False
   Worksheets("Risk").Range("N:U").AutoFilter field:=1, Criteria1:=filterCriteria, visibleDropdown:=False
   Worksheets("Compliance").Range("N:U").AutoFilter field:=1, Criteria1:=filterCriteria, visibleDropdown:=False
   Worksheets("Audit").Range("N:U").AutoFilter field:=1, Criteria1:=filterCriteria, visibleDropdown:=False

 

[ravishankar]

Hi
Not clear as to what you want. do you want process 1 to be listed wherever it occurs in cols N to V?
Ravi

 

[Pasty]

Yes thats it or whatever they need to search for. I'm going to have an input box that they enter what they're looking for and then it will filter this across columns N:U to see if it is in any of them.

 

[Fazza]

What if you use an advanced filter and populate every field with the value you want?

 

[Pasty]

Hi,

I'm not sure how to do this.

 

[Fazza]

Hi,

Suggest you read Excel help. Search for "advanced filter".

If you google you can find info too. Such as http://www.contextures.com/xladvfilter01.html

Or probably any Excel book.

Regards, Fazza