Data Validation Based on User Input

[dmcgoo]

Hi all

In the spreadsheet shown below I would like the user to select a project via a dropdown list in cell B2 which is from the data set shown in row 7 downwards. Then based on the project they select, they need to be able to see all of the locations associated with that project and choose in B3. Finally they then need to be able to select a team which is associated with the project & location combination chosen in cells B2 and B3.

I have searched on the forums but can't seem to find a solution to this. Can anyone help with this?

Many thanks!

McGoo

Excel 2007
	A	B	C
2	Project
3	Location
4	Team
5
6	Project	Location	Team
7	Project 1	Perth	Team 1
8	Project 1	Melbourne	Team 2
9	Project 1	Sydney	Team 1
10	Project 1	Brisbane	Team 1
11	Project 1	Brisbane	Team 3
12	Project 1	Darwin	Team 4
13	Project 1	Darwin	Team 5
14	Project 2	Perth	Team 3
15	Project 2	Perth	Team 4
16	Project 2	Melbourne	Team 1
17	Project 2	Melbourne	Team 2
18	Project 2	Sydney	Team 4
19	Project 2	Brisbane	Team 6
Sheet1

<p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120

 

[Mohammad Basem]

You are right and it was very nice of you raising this issue to help organising the tables.

Thank you!