Hi, I'm new here!

I have a table on sheet 1, and there is a number of collumns worth of information. In column R, I have a simple "Yes" or "No" list. If A cell is "Yes", I want to automatically populate the cells of sheet 2, and pull some of the entered informaiton from sheet 1 into sheet 2. Is there a way I can populate consecutive rows in sheet 2 based on "Yes". i.e. not a load of blank rows with occasion info from sheet 1.

Hope this makes sense!

Thanks