Filter on the "Paid" column for "1"
Edit | Go to | Special | Visible Cells Only
Copy
Paste on another worksheet.
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
editorial review of excel sorting add-in (30 ways to sort)




"Ray"
wrote in message
...
Hi,
I have a worksheet with columns containing name, address, age, phone etc.
The last column says whether they have paid their subscription (if yes '1' if no '0')
I need to transfer all the rows with '1' in the 'Paid' column to another worksheet.
How do I do this, please?
Thanks,

Ray