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.