Copying whole rows based upon one criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI,

I would like to be able to copy entire rows of data from around 30 column
headings based upon one certain column which contains a "Y" if i want the
entire record (row).

I would need to put this is a new sheet? What formula would I need to enter
on the new sheet?
 
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
Creating a new sheet from specific data in existing sheet 3
copy/paste row with one formula 6
Summing rows based upon condition 2
Macro - Copy row base on criteria 3
Auto Copy Data from one worksheet to another 1
(2003) Conditional copying&pasting 1
Excel Macro to copy a row to another sheet based on date 0

Back
Top