I have the following code that I would like to add critieria too, however I can not get it work based on what I added
Dim ChkSH As Worksheet
Set ChkSH = Sheets("LM")
ce = "Local Market"
For Each ce In Range("a4:a" & Cells(Rows.Count, 1).End(xlUp).Row)
Set findit = ChkSH.Range("a4:a3000").Find(what:=ce, LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
If findit Is Nothing Then Range("A" & ce.Row).Copy _
From the Variance worksheet I want to only compare and copy over the rows where Column B text = Local Market. As it is written I am returning all values in Column B.