Can anyone help me do the following...

I have a long list of names in column A and corresponding numeric
values in B of sheet 1.

These values relate to different categories and i want to split the
original list in sheet 1 into 5 sheets depending on the category.

Imagine the list consists of the following...

Dog 100
Doggy 50
Doggie 150
Kitten 75
Kitty 100
Kittens 120
Bird 90
Birdie 110
Birdy 25


I want to split the list into three category "Dog", "Kit" and "Bird".

Is it possible to put a formula in sheet 2 to search the original list
in sheet 1 and pull all of the entries containing the word dog (in this
case 'dog, doggy, doggie' and any other variations featuring 'dog') and
the respective values from sheet 1 into the second sheet.

Many thanks for your help


---
Message posted from http://www.ExcelForum.com/