Extracting conditional data from different sheet

[ravan16]

Hi,


I'm not sure which sub-forum to post my queries, so I'm posting at 2 sub-forums, Kindly guide if possible.

I need help with the following.
I have 2 worksheets, Preapproved and People
In Preapproved, there is table where each Role being defined with the relevant Responsibility.

What I am trying to achieve here is in the second sheet - People.
1.) Create a dropdown box for Role based from Preapproved sheets Role
2.) Automate the population of the Responsibility in People sheet once the user have selected the right Role.


Together I'm attaching the sample excel sheet > MFG NewHire IT Doc.xlsx

Thanks in Advance.
Let me know if I have posted in the wrong sub-forum