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