Copy certain cells from one sheet to another with a condition

H

hamad.fatima

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
 
G

Gord Dibben

How about Data>Autofilter and filter on column N for "X"

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


Gord Dibben MS Excel MVP
 
Top