Copy certain cells from one sheet to another with a condition

  • Thread starter Thread starter hamad.fatima
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Copy corresponding cell in Column B if cell in A contains certain text? 1
Transferring only certain rows to seperate worksheet 8
Copy is criteria met 3
Copy certain cells in a row to another sheet, based on certain val 2
Help needed urgently 3
Copy summary data to new sheet 1
Excel Macro to copy a row to another sheet based on date 0

Back
Top