Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
drop downs in excel
Hi! I need to figure out how to populate neighboring cells when an option is
selected in a drop down box. For instance, I have a table with data and I have a new worksheet with drop downs so I can choose something from column A on that table. I would like for the next two columns in my new worksheet to populate with the information from column B and C in the table when an item in the drop down menu is choosen. Can you help? Thanks so much! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
drop downs in excel
http://www.contextures.com/tiptech.html
-- Don Guillett Microsoft MVP Excel SalesAid Software "Kisred" wrote in message ... Hi! I need to figure out how to populate neighboring cells when an option is selected in a drop down box. For instance, I have a table with data and I have a new worksheet with drop downs so I can choose something from column A on that table. I would like for the next two columns in my new worksheet to populate with the information from column B and C in the table when an item in the drop down menu is choosen. Can you help? Thanks so much! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
drop downs in excel
More specifically, you're looking at the "data validation" entries!
On Feb 28, 10:22*am, "Don Guillett" wrote: * * *http://www.contextures.com/tiptech.html -- Don Guillett Microsoft MVP Excel SalesAid Software "Kisred" wrote in message ... Hi! *I need to figure out how to populate neighboring cells when an option is selected in a drop down box. *For instance, I have a table with data and I have a new worksheet with drop downs so I can choose something from column A on that table. *I would like for the next two columns in my new worksheet to populate with the information from column B and C in the table when an item in the drop down menu is choosen. Can you help? Thanks so much!- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating drop downs in a cell contingent on another drop down | Excel Discussion (Misc queries) | |||
Drop downs | New Users to Excel | |||
Excel buttons and drop downs | Excel Discussion (Misc queries) | |||
Excel Keyboard Use for Drop Downs | Excel Discussion (Misc queries) | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions |