R
Ratedr
I dont know if I can explain this properly on this NG, I might have to
explain it better with an actual sheet, but I want to do something
with dropdown menus, between two sheets. Here is what would be on
the information sheet
a b c d e
f g h i
PO quantity width height top inside
size metal style
1 2.2 1.8 flat
aacf 7.5 14w 085/070/aabi
2 2.4 1.8 dome
nocf 6 pd 095/rd/070
3 7.2 2.2 lowdome
aacf 8 14w 285/fr/085/aabi
c->h on the sheet above are the information that I would be using to
get the result in i (a, or PO, and b, or quantity, will be #s that the
customer will enter, that will be transferred to the next page.
There will be dropdown menus on a page with choices of width, height,
top, inside, size, and metal. Now, I would like to create a page,
with up to 20 dropdown menus of the same 6 choices mentioned above to
give me the result on a seperate page. For example, if my customer
entered PO of 1234, and quantity of 2, and then in the dropdown menus,
in order 2.2, 1.8, flat, aacf, 7.5, 14w...the result given would be
a b c d
e
PO quantity style size metal
1234 2 085/070/aabi 7.5 14w
If I chose, in order, with the same PO and qty 7.2, 2.2, lowdome,
aacf, 8, 14w..the result would be
a b c d
e
PO quantity style size metal
1234 2 285fr/085/aabi 8 14w
and so on.
If you have any questions, which Im sure you do because Im explaining
it in what looks like Chinese to me (and Im the one that wrote it!),
please email me at (e-mail address removed)
Thanks
Scott
explain it better with an actual sheet, but I want to do something
with dropdown menus, between two sheets. Here is what would be on
the information sheet
a b c d e
f g h i
PO quantity width height top inside
size metal style
1 2.2 1.8 flat
aacf 7.5 14w 085/070/aabi
2 2.4 1.8 dome
nocf 6 pd 095/rd/070
3 7.2 2.2 lowdome
aacf 8 14w 285/fr/085/aabi
c->h on the sheet above are the information that I would be using to
get the result in i (a, or PO, and b, or quantity, will be #s that the
customer will enter, that will be transferred to the next page.
There will be dropdown menus on a page with choices of width, height,
top, inside, size, and metal. Now, I would like to create a page,
with up to 20 dropdown menus of the same 6 choices mentioned above to
give me the result on a seperate page. For example, if my customer
entered PO of 1234, and quantity of 2, and then in the dropdown menus,
in order 2.2, 1.8, flat, aacf, 7.5, 14w...the result given would be
a b c d
e
PO quantity style size metal
1234 2 085/070/aabi 7.5 14w
If I chose, in order, with the same PO and qty 7.2, 2.2, lowdome,
aacf, 8, 14w..the result would be
a b c d
e
PO quantity style size metal
1234 2 285fr/085/aabi 8 14w
and so on.
If you have any questions, which Im sure you do because Im explaining
it in what looks like Chinese to me (and Im the one that wrote it!),
please email me at (e-mail address removed)
Thanks
Scott