Pointer please

[KiwiBrian]

I have 2000 rows of data with 6 columns/fields.
Lets say that Column A is the objects, e.g, rhubarb, cat, woodpecker, car,
etc.
I have created a seperate 2 column list equating each object name to a
higher level category name e.g. fruit, animal, bird, vehicle etc.
So there will be several different Column A categories that will all be
given the same 'higher level category name' in my 2nd list.
E.G. in column A, cat, dog, pig, cow, etc will all be given the same higher
level category name of animal in my 2nd list.
Now for my query.
I want to add an extra column to the 6 column data list and have the correct
'higher level category name' in it for each row.
Then I want to be able to create from the first list, with its extra higher
level category fields, only and all, the rows that correspond to each
'higher level category name'.
Hence from 1 database I will be creating a lot of seperate databases,
containing only the entries corresponding to the 'higher order'.
Can anyone tell me if I am going about this the right way, and if so what is
the correct terminology for the two operations that I need to do.
Then I can research it myself further.
TIA
Brian Tozer

 

[Kieran]

Brian,

The extra column can be added using the VLOOKUP function. Have a loo
at the online help and post back if there are any problems. (Tip ensur
that the list of object/category, has the object in the first column
the actegory in the second column)

Separating the list can be done with autofilter. You could leave th
master filter untouched, or copy the filtered set to another place.
(Advanced filter will do this too, but it is a little harder to set up