Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter problem
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter problem | Excel Discussion (Misc queries) | |||
problem with filter | Excel Discussion (Misc queries) | |||
Filter problem | Excel Worksheet Functions | |||
filter problem | Excel Discussion (Misc queries) | |||
Filter problem | Excel Worksheet Functions |