Prev: Copy to filtered blank rows from another spreadsheet
Next: '07 Large Operation Error (Delete / Insert Rows and/or Columns)
From: Henry on 28 Apr 2010 15:21
I'm trying to create a schedule which allows the user to select a state, and
based on the state selected, to choose a county or city within that state.

Can this be done, if so how?
--
Henry
From: Bob Umlas on 28 Apr 2010 15:26
yes - send your email address and/or your file to me and I'll demo how it's
done -- easier to show than describe - send to me at bobumlas(a)yahoo.com
Bob Umlas Excel MVP

"Henry" <Henry(a)discussions.microsoft.com> wrote in message
news:69E9B006-EBBB-4FCA-A9B5-F86AAAB3D8E3(a)microsoft.com...
> I'm trying to create a schedule which allows the user to select a state,
> and
> based on the state selected, to choose a county or city within that state.
>
> Can this be done, if so how?
> --
> Henry

From: Gord Dibben on 28 Apr 2010 16:14
I would use Data Validation dropdowns that are drill-down dependent.

Pick a state then pick a county then pick a city

See Debra Dalgleish's site for how-to and a sample workbook.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Wed, 28 Apr 2010 12:21:01 -0700, Henry <Henry(a)discussions.microsoft.com>
wrote:

>I'm trying to create a schedule which allows the user to select a state, and
>based on the state selected, to choose a county or city within that state.
>
>Can this be done, if so how?

 | 
Pages: 1
Prev: Copy to filtered blank rows from another spreadsheet
Next: '07 Large Operation Error (Delete / Insert Rows and/or Columns)