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

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

On 3 Apr, 13:06, "Roger Govier" wrote:
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
sitehttp://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- Hide quoted text -

- Show quoted text -

Hi,

I have tried this but now it copies all the filter cell details into
the new street. It doesnt seem to filter it... Help!

Thanks

Princy

Hi

On Sheet2 copy the column headings that you wish to see brought over
from Sheet1 onto say Row 4 of sheet2.

For example, if you only want Owner Name and Number of Confs, then enter
these headings into A4 and B4.
In the final step of Advanced Filter
Copy toSheet2!A4:A5
--
Regards

Roger Govier


wrote in message
ups.com...
On 3 Apr, 13:06, "Roger Govier" wrote:
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
sitehttp://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- Hide quoted text -

- Show quoted text -

Hi,

I have tried this but now it copies all the filter cell details into
the new street. It doesnt seem to filter it... Help!

Thanks

Princy