| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down lists to transfer data between worksheets
Hello Patrick
Using Data Validation, you can quite easily create the dropdown list. For detailed instructions, see he http://www.contextures.com/xlDataVal01.html To retrieve the data from the first sheet, a VLOOKUP function will suffice. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "patrickj" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down lists to transfer data between worksheets
Thank you Wigi. I will try these two steps
-- Patrick Johnstone, UK "Wigi" wrote: Hello Patrick Using Data Validation, you can quite easily create the dropdown list. For detailed instructions, see he http://www.contextures.com/xlDataVal01.html To retrieve the data from the first sheet, a VLOOKUP function will suffice. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "patrickj" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Direction combine several excel worksheets, drop down lists and da | Excel Worksheet Functions | |||
| How do I add data to drop down lists? | Excel Worksheet Functions | |||
| data validation and drop down lists | Excel Discussion (Misc queries) | |||
| Transfer data from multiple worksheets | Excel Discussion (Misc queries) | |||
| data validation - Drop Down Lists | Excel Discussion (Misc queries) | |||
Linear Mode
