I need to pull values from multiple cells in a single row and place
them into another worksheet in specified cells. I have setup a pull
down in Worksheet2 to show all of the values in a column on Worksheet1.
When I select one of these values in the pull down I need to grab 6
other cells in Worksheet1 (from the same row) and place them into
Worksheet2 in different rows/columns.
Is this possible, and do I need to use a macro to accomplish this?

I appreciate any help.

Thanks,

Chad