Product/Price menu

R

Rbalse

I am trying to create an order form on which users select products fro
a menu, by "ticking" a box.
For each ticked box, the price is displayed.
and all prices for ticked items are totalled.
A sample of a worksheet doing this would be helpful
 
D

Dave Peterson

I think I'd try it with worksheet formulas to see if that was sufficient.

Column A will hold the quantity (not check mark!)
column B will hold the part number(?)
column C will hold the description
column D will hold the Unit Price
column E will hold the extended price.

On a different sheet (named Prices), put your partnumbers in column A, the
description in column B and the price in column C.

Then use a formula to return the description in column C of the first worksheet:

=vlookup(a2,Prices!$a:$c,2,false)

But in column D, check for the quantity first:
=if(a2="","",vlookup(a2,prices!$a:$c,3,false))

Then in column E:
=if(a2="","",d2*a2)

======
The checkbox may look prettier, but then you could only order one per line.
 
Top