Hello!

Can anyone help me insert a drop down list that is attached to a bunch of data to make it easier to navigate through the data.

Therefore, when you chose one item in the list it will populate data in the worksheet for that item in the list and change for each item in the list.

For example, if you have ten people's names in the list when you pick Nancy it will show you information on her and when you pick Scott it will populate with completely different data. The data all coming from one master tab.

Thank you in advnace for your help!
Emily