hi, i run www.GungeShop.com and i sell two types of product. gunge and collection boxes.

basicaly i want a system that will tell me how many collection boxes i have left, and of which colour. i currently keep a record of all my sales and details in an excel spreadsheet so it would be easy to do something like this if only i could work out a way to extract all the collection boxes from the list. i need it so that any collection boxes are logged in a seperate worksheet and then colours and quanities of each order are seperated and deducted from the ammount i have in stock.

basicaly, i need a way of extracting any entries that are collection boxes so i can get their colour, and quantity details.

i have tried a lookup but no success.

any help greatfully recieved.

Thanks,
Pete