Thanks Debra

It works a treat.

"Debra Dalgleish" wrote:

You could add another column to your table, and use it to check for
occurrences of the code in any column. For example, assuming codes are
in columns B:L --

In cell O1, type the code you want to filter for.
In cell M1, type the heading, "Check"
In cell M2, enter the formula: =COUNTIF(B2:L2,$O$1)0
Copy the formula down to the last row of data
Filter the Check column for TRUE


DP wrote:
Hi everyone

Is there a way I can filter on multiple columns?

For example, my worksheet has several "code" columns. The same code may
appear somewhere in all of the "code" columns. I need the ability to be able
to filter on all the columns.

I realise Autofilter is not the answer, however, I have to have autofilter
switched on so that I can filter on the rest of the columns in the usual way.

So what I'm really looking for is the ability to have autofilter on columns
A - J and then some other type of filter to give me the ability to filter on
columns K - P simultaneously.

Is this possible?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html