Thread: Filter problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ray[_7_] Ray[_7_] is offline
external usenet poster
 
Posts: 2
Default Filter problem

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