|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Drop down menu
"Gord Dibben" wrote:
Randall
See Debra Dalgleish's site for how-to.
http://www.contextures.on.ca/xlDataVal02.html
Thank you for the great information, I found it very useful and easy to administer. I am on to the next level, VLookup and IF statements.
Randall
On Mon, 27 Nov 2006 09:27:01 -0800, Randall
wrote:
Ive created a drop down list box from the Data Validation tab with the
following text, Austin, Houston, and Dallas. I created another drop down
list for an each cities stores (each has15 locations). I want choose one city
and only the corresponding locations will show, how do I accomplish this
task? Is there a formula I need to create?
Thank you in advance,
Gord Dibben MS Excel MVP
|