Autofilter with criteria from other sheet

He guys,

An issue that I unfortunately can't solve with autofilter. I've got a code that works partly for my goal. Hereby the situation: I've got a list with numbers in column B (sheetname: sheet1). There needs to be set up a filter but the criteria (multiple) are in an other sheet. The code that I've now got only filters on a value that is in the same sheet. Below the code:

Please Login or Register  to view this content.

The new code needs to:
- get the criteria from sheet 2 (A2: A6)
- filter the data in sheet 1 (column B) based on the criteria from sheet 2

If needed, I can provide a test sheet.

Thanks for all the effort.

Cheers

Originally Posted by Richard Buttrey

Hi,

Presumably

Please Login or Register  to view this content.

Hi Richard,

Unfortunately it didn't work. I get an error: object required 424. Is there a solution to solve this?

I've modified the code a bit and with the bellowing code I get an "subscript is out of range"-error:

Please Login or Register  to view this content.