Categories in Databases

Y

yl358

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
 
R

Ragdyer

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>
 
C

CLR

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
 
M

m96

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)
 
Top