Filtering multiple columns at once

Pasty

Board Regular
Joined
Mar 26, 2007
Messages
96
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.

Code:
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
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
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
 
Upvote 0
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.
 
Upvote 0
What if you use an advanced filter and populate every field with the value you want?
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,243
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top