dynamic cretiria- advanced filter

[avishain]

hello ,

i got a table in sheet 1 and in sheet 2 i got cretirias.


i want to use the advanced filter and record a macro that will filter the table according to these cretirias .


the problem is ,i need to suply a criteria range when i use the advance filter ,and my cretirias might vary from time to time.

for instance,it can be 2 rows criteria and can be only 1 row criteria. ( i can't choose a blank row for criteria cause the filter won't work and will give me the whole table).

how can i use a macro that will aut take the exact range of my criterias ?

thanks