excel dropdown question

[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

 

[TheQuickBrownFox]

repost using a proportional font

 

[Ratedr]

repost using a proportional font











- Show quoted text -

how do I do that? can I email you an example of what Im talking about?

 

[Don Guillett Excel MVP]

how do I do that?  can I email you an example of what Im talking about?- Hide quoted text -

- Show quoted text -

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."

 

[WallyWallWhackr]

Examples of my workbooks which use range names and cell values to
construct on-the-fly drop downs can be found on the Microsoft user
submitted template site or at this mediafire location:


http://office.microsoft.com/en-us/providers/PN030000658.aspx?=&CTT=102&Origin=EC079000032


The mediafire link:

http://www.mediafire.com/file/tfvy2s9atb8gg7v/menupicker.xltx

That is a menu picker sheet I made. The annual time sheet is a pretty
good one too.

The whole archive has several sheets which use dynamic menu methods.

http://www.mediafire.com/?sharekey=oct6lczbct3wl


I really need to document my method, and make it easier to understand
the manner in which I use range names to simplify formulas, etc.