Copy contents and paste into newly inserted row

[Hopper]

Please Login or Register  to view this content.

I can use this code above to insert a new row below the last combination of Sale (Column D), Purchaser (Column E), and Solution (Column G). After inserting the row I would like to copy the contents from Sheet2 range B2:P2 and paste them into the new row in Sheet1. I am interested in any help I can get with with that.

Here is what I am trying to add to the code above

Please Login or Register  to view this content.

but since I don't know the row I am not sure how to finish it. Thank you for your help.

[Richard Buttrey]

Hi

Maybe the following...?

Please Login or Register  to view this content.

HTH

[Hopper]

Hey Man, thank you for the help. The inserted row works very well thanks for your input. However I am still having trouble with the copy and paste; It is not working. Here is the code I am using. What do you think?

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

Not quite sure what you are trying to achieve but if this doesn't work upload your workbook along with a notes as to what you expect to see and where after the macro has run,

Please Login or Register  to view this content.

Regards

[Hopper]

This is awesome. Works beautifully. Thank you very very much!