How do you make a....

[Akusuzaku]

Dropdown Menu, but then a program that imputs information when a certain one from the dropdown menu is selected.

Making an order form that auto puts in information depending on which vender the user selects.

So, for instance. If the user selects "Wal-mart" ( I know bad example lol), in the 5 empty cells below it fills out the address that I specify.

Thanks in advance

[RagDyer]

Check out his site of Debra Dalgleish.

Scroll down to the D's, and read all the pages on "Data Validation", which
is probably the feature that you should use:

http://www.contextures.com/tiptech.html

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Akusuzaku" <Akusuzaku.1sugxk_1122494849.504@excelforum-nospam.com> wrote in
message news:Akusuzaku.1sugxk_1122494849.504@excelforum-nospam.com...
>
> Dropdown Menu, but then a program that imputs information when a certain
> one from the dropdown menu is selected.
>
> Making an order form that auto puts in information depending on which
> vender the user selects.
>
> So, for instance. If the user selects "Wal-mart" ( I know bad example
> lol), in the 5 empty cells below it fills out the address that I
> specify.
>
> Thanks in advance
>
>
> --
> Akusuzaku
> ------------------------------------------------------------------------
> Akusuzaku's Profile:
http://www.excelforum.com/member.php...o&userid=25633
> View this thread: http://www.excelforum.com/showthread...hreadid=390719
>

[Debra Dalgleish]

You can use data validation, and vlookup formulas to do this. There are
instructions in Excel's Help, and here:

http://www.contextures.com/xlDataVal01.html

http://www.contextures.com/xlFunctions02.html

and instructions for an order form here:

http://www.contextures.com/xlOrderForm01.html

Akusuzaku wrote:
> Dropdown Menu, but then a program that imputs information when a certain
> one from the dropdown menu is selected.
>
> Making an order form that auto puts in information depending on which
> vender the user selects.
>
> So, for instance. If the user selects "Wal-mart" ( I know bad example
> lol), in the 5 empty cells below it fills out the address that I
> specify.
>
> Thanks in advance
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html