Filter problem

[Ray]

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

 

[James Ravenswood]

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

You can use AutoFilter to display only the rows with '1' and then do a
copy/paste.

See the autofilter sections of

http://www.contextures.com/tiptech.html