Hi,

I have a database of things in Sheet1 and one of the columns is labeled
"country". Let's call this the master list, with about 150 rows.

I want to make a list in Sheet2 with just things in "China". The way
I've been doing it is by scouring through the master list, seeing which
ones have "china", and then manually copying and pasting. Is there any
way in which I can get this automatically done instead of doing it the
manual labor way? Thx


--
yl358
------------------------------------------------------------------------
yl358's Profile: http://www.excelforum.com/member.php...o&userid=35776
View this thread: http://www.excelforum.com/showthread...hreadid=568039

Can be done with formulas, but definitely, the right way to go is with
either filers or a Pivot table.

Check out this web site of Debra Dalgleish:

http://www.contextures.com/tiptech.html

Scroll down to "F" for the filters, and start at the *last* entry under the
P's for a pivot table intro>
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"yl358" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> Hi,
>
> I have a database of things in Sheet1 and one of the columns is labeled
> "country". Let's call this the master list, with about 150 rows.
>
> I want to make a list in Sheet2 with just things in "China". The way
> I've been doing it is by scouring through the master list, seeing which
> ones have "china", and then manually copying and pasting. Is there any
> way in which I can get this automatically done instead of doing it the
> manual labor way? Thx
>
>
> --
> yl358
> ------------------------------------------------------------------------
> yl358's Profile:
> http://www.excelforum.com/member.php...o&userid=35776
> View this thread: http://www.excelforum.com/showthread...hreadid=568039
>

Check out the feature Data > Filter > AutoFilter > and select China from the
drop-down arrow at the top of the column..........

hth
Vaya con Dios,
Chuck, CABGx3



"yl358" wrote:

>
> Hi,
>
> I have a database of things in Sheet1 and one of the columns is labeled
> "country". Let's call this the master list, with about 150 rows.
>
> I want to make a list in Sheet2 with just things in "China". The way
> I've been doing it is by scouring through the master list, seeing which
> ones have "china", and then manually copying and pasting. Is there any
> way in which I can get this automatically done instead of doing it the
> manual labor way? Thx
>
>
> --
> yl358
> ------------------------------------------------------------------------
> yl358's Profile: http://www.excelforum.com/member.php...o&userid=35776
> View this thread: http://www.excelforum.com/showthread...hreadid=568039
>
>

use autofilter and then copy them (visible cells) to the new sheet.

use something like this:

set w = activesheet
w.usedrange.autofilter
w.usedrange.specialcells(xlvisible).copy
set s = thisworkbook.worksheets.add
w.paste destination:=s.cells(1,1)



yl358 wrote:
> Hi,
>
> I have a database of things in Sheet1 and one of the columns is labeled
> "country". Let's call this the master list, with about 150 rows.
>
> I want to make a list in Sheet2 with just things in "China". The way
> I've been doing it is by scouring through the master list, seeing which
> ones have "china", and then manually copying and pasting. Is there any
> way in which I can get this automatically done instead of doing it the
> manual labor way? Thx
>
>