Hi
I have set a Data Validation List.
What I want to do is when you choose from the drop down menu, it cell next to it shows different options.
E.g You chose say manager John Smith in A1 and then B1 has a list to choose from of his team, but if you choose Paul Brown as manager in A1, B2 has his team to choose from.
Any help will be much appriated
Bookmarks