Hello All,

I think this one should be easy, I just can't seem to get the right formula down. I have information that is laid out in rows on an excel spredsheet. When I get to a row that has a specific piece of information then I want to copy that whole row, and put it into a new sheet on the same Excel workbook. Below is the code that I am trying so far. Can someone let me know what is wrong. Thank you.

if usit1 = ("USIT") then
xls.sheets("sheet2").range("A" & count4).currentregion
count4 = count4+1
count3 = count3+1
goto end_proce1
elseif usit1 <> ("USIT") then
count3 = count3+1
end if