Copy based on two variables

[proctk]

Hi

I have a database that I want to copy the entire row to another worksheet if the values in two rows match the values in a sheet called “switch in” cells B2 & B3. The first sheet is called “datalist” and the rows that I’m trying to match are rows 1 and 3

The data needs to be copied to the sheet called “Switch In” starting at row 5

The value in row 1 is a date, so if the date land within the month in Cell B2 and the value in Row 3 matched the value in cell B3 then the entire row needs to be copied.
Thank you

I don't know were to start

 

[NateO]

Try turning on your macro recorder, and using an autofilter of for your criteria. Copy the filtered data.

Go back to the code and make the criteria variable, based on your range. E.g., instead of:

Criteria1:=">=0.2"

You'd want:

Criteria1:=">=" & sheets("switch in").range("b2").value

Cross posted:
http://www.xtremevbtalk.com/showthread.php?t=213654

 

[proctk]

I tried manythings based on the attached recomendations but no luck, can someone please post an example