Through Google search, I found solution to my second query from this thread on another forum,

Copy entire row if Cell(Cells) in row contains specific string