I have 2 tabs. One tabs lists the names and the dates and other
onformation about the names in 600 rows.
Column N has the type of the entry. If its "X " then i need to copy few
entreees of the data from that row to another sheet . The the next
entry and so on till the 600 rows are completed. If the entry in column
N is "Y" then do not copy the information.

I would really appreciate any help.

thanks