Excel Macro

Hello, i am looking for some advice or any bright ideas.

I have an excel sheet with three columns, (type, name, and number allocated) Say for example i am colecting animals. I have wolf, bear, timber wolf and rabit. (these are the types) Now i want to count them. (#'s puled froma database) I can count them easily. The twist is that wolf and timber wolf are related fields, so i want the total of them. But i don't know how to tell they are related? The user must specify.

So what i am thinking of doing is adding a column, so that everythign that has a lable, 1's are related, 2's are related and so on so the user can specify what he she wants to be related. So if i were to do that then how would i bable to add up the totals if i don't know when the last one is reached. Also i may be adding in rows at any given time, so they can not be hard coded, and i may be adding new ones to the database. Also wolf could be a 1 and timber wolf be a 25. There may be more #'s inbetween wolf and timber wolf and i have to total those two.

Does anyone have any suggestions or comments, it would be greatly appreciates.


Thnx alot

Hello all, thanks for taking the time to think about it, but i have already solved the problem. take care