Filter data by multiple criteria

Hello everyone
I need to filter data by multiple criteria ..
My data is in sheet1 and the field Auto ID is the target field
My criteria is in sheet2 >> Range("A5:A" & Lastrow)

I Can filter data with this code

Please Login or Register  to view this content.

Everything till now is ok
I need to filter the range of criteria itself and to filter my data according to visble cells only
In other words to store the variable Crit to assign only visible cells
I tried to add .SpecialCells(xlCellTypeVisible but I have an error
Thanks advanced

Hi Yasser,

This works:

Please Login or Register  to view this content.

What would you like to do??

Mr. xladept
Thanks for reply
The code I posted in post 1 works fine ..I'm filtering data in sheet1 based on the criteria in sheet2 (stored as array)
Now I need to store the criteria in sheet2 even if I filtered the criteria itself ..

Try

Please Login or Register  to view this content.

Mr. PCI
Thank you very much for this great solution.
I think it may be easier by using this :
.SpecialCells(xlCellTypeVisible

Generally it helped me a lot

Hi Yasser,

PHP Code: 

I think it may be easier by using this :
.SpecialCells(xlCellTypeVisible 


Can you explain what you mean ...?
In the code sent it is used ..!
The only issue is that you cannot turn visible cells to an array without reading cells one by one.
PCI

The only issue is that you cannot turn visible cells to an array without reading cells one by one.

Now I got it
Thank you very much for your great help