Hi,

To understand how to use Advanced Filter, refer to topic "Filter by using
advanced criteria" in the Microsoft Excel 2003 online help and then complete
the following steps.

Do the following:

1. On the Data menu, point to Filter and then click Advanced Filter.
The Advanced Filter dialog box appears.
2. Under Action, click the Copy to another location option.
3. In the List range text, click and then select the range.
4. In the Critera range text box, click and then select the crtirea range.
5. In the Copy to text box, click Sheet2 -worksheet-tab, and select the new
location.
6. If you want to extract only unique records from the list, then select the
Unique Records only check box or retain the default setting.
7. Click OK to save the settings and to return to the worksheet.

Challa Prabhu

"Madduck" wrote:

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