Update entire row based on one cell value

Hi,

I need to poupulate all cells in a row based one perticular cell value. Example: The attached excel file has 2 sheets. On sheet 1, it has a data set table which will be updated everyday. On sheet 2, I need to update the table based on cell value"YES". If the cell value is "NO" it has to skip to next row which has "Yes" and populate sheet 2. Any help is greatly appreciated.

Thanks