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?

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.

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?

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?