hi

i'm having a problem with my excel wine orderform spreadsheet. i have three cells for wine selection which have changable wine quanities next to them quanities. the three wine selection cells are linked to the same list on another sheet of the workbook.
Case Types Price(inc VAT) Quantity Total
White 45.99 1 45.99
Red 47.99 2 95.98
Mixed 46.99 3 140.97
i need to vaildate the wine case types so that the same wine type can not be selected more than once. i need to vaildate it using Visual Basic and i have a limited knowledge on teh subject and i was wondering if anyone could help.

thank you
jessica