Hi

On sheet2 in cell A1 type City, in cell A2 type Weybridge.
Now, starting from sheet2, DataFilterAdvanced FilterCopy to another
location
List rangeset your data range on sheet1
Criteria rangeSheet2!A1:A2
Copy toSheet2!A4

For lots more help on Advanced Filter take a look at Debra Dalgleish's
site
http://www.contextures.com/xladvfilter01.html#ExtractWs
--
Regards

Roger Govier


wrote in message
oups.com...
Hi,

Thanks in advance for your help.

I'm trying to copy some data from my worksheet to a new sheet. The
background is like this:-
Column A Col B Col C Col D
Owner name Country City No of Confs

I want to filter the sheet to display the Owner name and No of Confs
column into a new sheet, with a criteria that City = Weybridge..

If you could please help.

Princy