Posted to microsoft.public.excel.misc
|
|
order form
Hi,
Check the links below, it should get you started.
http://www.contextures.com/xlDataVal13.html
http://www.contextures.com/xlFunctions02.html
Hope this helps!
Jean-Guy
"Abe" wrote:
help please....
i am trying to create an order form. normally this would be easy
enough...item price x quanity etc, but there are some other variables.
allow me to explain....
1. let's say we are selling products 1 2 3 etc all the way to 250.
2. let's say that products 1 through 50 only should display options (styles)
of a b c d e f and g, while products 51 -100 should display options (styles)
of h i j k l m etc.
I was hoping the two things above could be in drop down boxes... so..for
example..a customer orders product 22, only the a to g options or styles are
shown.
Now..to complicate things a buit further, each style would have a different
price associated with it.
I was thinking somehow to have the products listed in a drop down box...and
depending on the product selected, would evoke some sort of condition (If
product = 22, display options a-g..where the options or styles are maybe in
an external file?
Does this make sense?
Hope so :)
Any ideas would be greatly appreciated. And please be gentle...I'm a
newbie...but then you probably know that already by the way I asked :)
Thaks in advance,
Abe
|