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!

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!

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 -