VBA code to copy specified sequential cells from Sheet1 row and create new row in Sheet2 when drop down triggered

[handoverhammer]

Hello Excel Wizards,

I have been experimenting with this all week, but I continue to get errors. Any help would be appreciated.

There are two sheets, 1 and 2. Sheet1 Column A is a drop down containing the value "New". When "New" is selected, I need values from Columns B:E in that row to be copied into Sheet2, creating a new row with the data from Columns B:E.

I have found examples for copying the entire row, but I only need the data from Columns B:E.

Thanks in advance!

 

[handoverhammer]

That will certainly work. Have a great weekend!

 

[Fluff]

Glad to help & thanks for the feedback