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!