Hi Charlesdh,

I mean to say select deselect only. What i mean to say is code should be such that it should select everything apart from what we have provided in sheet2 in drop down.

For example:

If i go to sheet2 and select "ES" in B2 and ":07:" in C2 then, then filter in sheet1 should select all rows excpt the rows which have ES:07: as one of their value. Thats why i said deselect the rows which we have selected in sheet2.