How about DataAutofilter and filter on column N for "X"

Select the data to copy then copy and paste to target sheet.


Gord Dibben MS Excel MVP


On 3 Jan 2007 12:16:35 -0800, "
wrote:

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