Help needed may need macro!!!

[jaiD]

I currently have a list formulas to produce a table of data on a work sheet such as:
South west
Area Submitted Passed Failed

Bristol 2 2 0
Bath 3 1 2
Avon 8 3 5

That works fine, what i am tying to achieve is a drop down list which will enable people to select the area they want to see and it populates the area names in column a where it currently says bristol bath avon. The forumla i have made for b,c,d would work out the rest based on the info on column a.

I currently have all the areas listed on a sheet within the file which is set up like this :

Row a Row b

South west bristol
south west bath
south west avon
london kent
london essex etc

So i need it to bring the data for column a from this.

Think this is quite challanging but hope someone can help i have seen somebody do similar on a macro but can't work out how they did it.

Thanks for any help.[/code]

 

[Bubbis Thedog]

I think you need a data validation list. Look up data validation list in either Excel or Google, and they lead you through it.

Bubbis