Data Validation with Dependent Lists?

[PamK]

I need to record projects by Region (Regions 1 - 5) and then by State.
I want to choose the particular Region from drop down in one column and then in the next column have it only show States in that Region.
These are the lists. There's probably a better way to set these up but this is what I came up with.
I know how to make the Regions column a drop down but then I'm stuck.
Any and all help is greatly appreciated

Region 1	Region 1	Region 4	Region 6	Region 8	Region 10
4	Connecticut	Alabama	Arkansas	Colorado	Alaska
6	Massachusetts	Florida	Louisiana	Montana	Idaho
8	Maine	Georgia	New Mexico	North Dakota	Oregon
10	New Hampshire	Kentucky	Oklahoma	South Dakota	Washington
	Rhode Island	Mississippi	Texas	Utah
	Vermont	North Carolina		Wyoming
		South Carolina
		Tennessee

Pam K

 

[arthurbr]

Have a look at How to make Excel Data Validation Dependent Lists