Coll1 contains 50 columns and 100 rows, I want to pick the complete row on the basis of condition that Coll1. Column2 & Coll1. Column3 & Coll1. Column4 matches a certain criteria, copy the complete row to a new Coll2 (blank). I know we can copy columns by explicitly mentioning them, but how can we copy the whole row?