Thread: Drop down lists to transfer data between worksheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PatrickJ PatrickJ is offline
external usenet poster
  
Posts: 7
Default Drop down lists to transfer data between worksheets
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.
--
Patrick Johnstone, UK
Reply With QuoteReply With Quote