Menu Help

[mccrimmon]

Hi guys

Im looking for somehelp here

Im trying to design a quick and fast way to look up account data on m
spreadsheet

I have many different countries in which we hold many different fund
and different account numbers for each countries funds

Im looking to have a drop down menu in which you can select the countr
you want

this will then show all the available funds for that country
then you select the fund and you get the account number your after

Cheers again

Brian

Please find attached the spreadsheet example

Please note there will be loads more countries, funds and accounts i
the real thin

Attachment filename: help.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=46751

 

[Andy B]

Hi

Have a look here for dependent drop-downs:

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

Andy.

 

[Bob Phillips]

Brian,

You are looking for dependent drop-down boxes.

Debra Dalgleish has an example at her site www.contexture.com, and I have a
working example workbook you can adapt if you want to mail me direct.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)