I have used excel for a few years but very basically. I have done some programming w/VB and i have done many databases with Access. I have a general idea how to use some programming with excel but total newbie. I have a pricelist with every item having 3 seperate prices from high to med. to low. There are 4 large groups of these items. I want to put in 4 sets of option buttons that will select for a single group the "high" "med" or "low" priced item and multiply it by the "quantity needed" the user has selected.
For instance column d is high price, column e is med. colum f is low
if the user selects option button High, if the user puts in 2 as the quantity needed, the total cost will multiply 2X the high price value