View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
cht13er cht13er is offline
external usenet poster
 
Posts: 141
Default 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 -