I have a worksheet:

set 1:
ID Paste?
1 N
2 Y


I have a second worksheet:

set 2:
ID
0
1

If I want to automatically paste the entire row from sheet 1 to the bottom of sheet 2 conditional on Y, how would I do this?