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
Bookmarks