Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interactive worksheet
How can I create a worksheet that allows a user to select an item from a
drop-down list and then have the adjacent cells filled automatically with the corresponding data from another worksheet? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interactive worksheet
Tria_Arch wrote: How can I create a worksheet that allows a user to select an item from a drop-down list and then have the adjacent cells filled automatically with the corresponding data from another worksheet? Have the drop down list index another list from the corresponding worksheet. So for you drop down have a list, have the output cell return the index number, use this number to index the other worksheet and return you value/string next to the dropdown. Hope this makes sence. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interactive worksheet
Unless you've got your heart set on writing a VBA program, you'd only need to
use Data Validation (to create the dropdown list) and the VLOOKUP function to find items from the list on the other sheet and return corresponding values. Debra Dalgleish's website has instructions for both: http://www.contextures.com/xlDataVal01.html and http://www.contextures.com/xlFunctions02.html Does that help? *********** Regards, Ron XL2002, WinXP "Tria_Arch" wrote: How can I create a worksheet that allows a user to select an item from a drop-down list and then have the adjacent cells filled automatically with the corresponding data from another worksheet? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interactive worksheet
That did the trick, thanks
"Ron Coderre" wrote: Unless you've got your heart set on writing a VBA program, you'd only need to use Data Validation (to create the dropdown list) and the VLOOKUP function to find items from the list on the other sheet and return corresponding values. Debra Dalgleish's website has instructions for both: http://www.contextures.com/xlDataVal01.html and http://www.contextures.com/xlFunctions02.html Does that help? *********** Regards, Ron XL2002, WinXP "Tria_Arch" wrote: How can I create a worksheet that allows a user to select an item from a drop-down list and then have the adjacent cells filled automatically with the corresponding data from another worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Publishing an interactive Excel worksheet on the web | New Users to Excel | |||
Interactive Worksheet | Excel Discussion (Misc queries) | |||
Interactive worksheet | Excel Programming | |||
How do I collect data from an interactive web worksheet and impor. | Excel Discussion (Misc queries) | |||
Office 2003 will not view interactive Worksheet saved as a web pa. | Excel Worksheet Functions |