| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to make a filtered list on a different sheet
Hi there was an answer to my question in this post :
GET UNIQUE ROWS FROM ONE PAGE TO ANOTHER 12/18/2005 10:20 PM PST but unfortunately the answers were in links that are no longer valid :( so here goes... I have a master list of data. I want to copy the entire row of data to a new sheet if the data in a certain column matches my criteria. There will be multiple rows that meet the criteria. and I will be wanting to place the columns in a different order.... Eg: MasterSheet Referral Source Consultant Inquiry Result Adviser Name John Sam MIC Appoint Mike John Paul Discuss SOA Sarah Carl Sam Question SOA Mike John Fred MIC SOA Mike Homer Sam Plan Appoint Sam Resultant Sheet ( required/wanted outcome) This sheet/List should only be populated with rows where Result = Appoint and the columns will be in a different order..... Result Adviser Name Referral Source Consultant Inquiry Appoint Mike John Sam MIC Appoint Sam Homer Sam Plan I am hopeing that the answer is a cell array in the Resultant sheet, so that I can arrange/exlcude columns as I need... Thanks in advance Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data from two sheets make up real time list in the new sheet?? | Excel Worksheet Functions | |||
| Data from two sheets make up a list in a third sheet (real time) | Excel Worksheet Functions | |||
| Can I make a list, on one summary sheet, of data collected from ma | Excel Worksheet Functions | |||
| Using TRIMEAN on a filtered list | Excel Discussion (Misc queries) | |||
| How can I make autofilter show the filtered number of rows | Excel Worksheet Functions | |||
Threaded Mode
