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

It would be good if you have a data base of your options or styles so you can
use a vlookup or index formula to find the proper data any time you pick the
client from your drop off list. Do you have the database? The other option is
that you can youse "if" formula. Evertything depends how your spreadhseet
looks like.
Eva


"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

Have a look at these two sites for some examples of data validation:

xlDynamic: http://www.xldynamic.com
Dynamic Dependent Dropdowns:
http://www.xldynamic.com/source/xld.Dropdowns.html

Contextures: http://www.contextures.com
Data Validation -- Create Dependent Lists:
http://www.contextures.com/xlDataVal02.html
Data Validation -- Dependent Dropdowns from a Sorted List
http://www.contextures.com/xlDataVal13.html

But in the end you need a datatable of the options as Eva suggested.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"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

You have replies in .excel and .excel.misc

For your help in future posting, it is better not to post the same
question individually to separate groups. Most of the regulars scan all
of the groups and it can waste an awful lot of peoples time answering a
question which has already been answered elsewhere.

--
Regards

Roger Govier


"Abe" wrote in message
news:4Ewvh.821731$1T2.212194@pd7urf2no...
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