Drop down lists to transfer data between worksheets

[patrickj]

I have one sheet with a list of countries and multiple data columns.
On a second sheet I have a graph to show this data for one selected country.
How can I insert a drop down list of the countries on the second sheet
and also transfer selected data for drawing on the graph?
At present I copy and paste the data.

 

[Wigi]

Hello Patrick

Using Data > Validation, you can quite easily create the dropdown list. For
detailed instructions, see here:

http://www.contextures.com/xlDataVal01.html

To retrieve the data from the first sheet, a VLOOKUP function will suffice.

 

[patrickj]

Thank you Wigi. I will try these two steps