I have a workbook where on sheet 1 if have the following data (a1:b27)

(Sheet 1 has 27 rows of data)

Y | Joe |

N | Frank |

Y | April |

N | Sandy |

Y | Rick |

N | Sam |

Y | Terri |

On Sheet1 above, if Column A equals "Y", I want to copy the name to Sheet2 below. If Column A equals "N", I go to the next row and check if Column A equals "Y", if so, copy the name to Sheet 2, if equals "N" go to the next row and continue to check and copy.

__I only want to copy over to Sheet 2 the name if Column A equals "Y".__

So utilizing my data from Sheet 1, Sheet 2 should look like below.

Joe | April | Rick | Terri | |

Planning & Organizing | ||||

Quality and Quantity of Work | ||||

Dependability | ||||

Knowledge and Skills | ||||

Inititative & Innovation |

How can I achieve this without using Nested If Statements?

Any help would be appreciated!