VBA to copy selected cells of a row to a second spreadsheet

[jekeith]

Hello,
I would like my workbook to copy selected cells from row x to a table on another sheet in the same workbook when I select a value from a drop down list in column z. The selected cells will need to be mapped to the correct columns in the second table. I have provided a workbook with headers to show what data should be mapped and where it should be mapped to.

[xladept]

There's no dropdown in Z and the headers don't jive with all of the categories

[jekeith]

Hello, my apologies...I meant column T, miffed on why I wrote z.

[xladept]

What about aligning the headers?

[jekeith]

I'm not sure I understand what you mean. All the columns on sheet 2 that need to be mapped are on sheet 1.

[xladept]

Here's event code for your Sheet1 module:

Please Login or Register  to view this content.