Copy active row and paste to specific cells on different sheet

Hello Everyone,

I am trying to create a sheet that logs test data. Real simple, a user would be entering the same data sets for different samples. Each individual sample would have it's own row.

The second sheet (Sheet2) I created a "Final Test Report" form (so it prints good) where I would like to have the data of the active row from Sheet1 be copied and pasted to. I am new to VBA so I cannot figure out how to copy the active row and paste it to Specific cells in a different sheet.

So, the starting row range in Sheet1 is A5:H5.

Sheet2 C11 = Sheet1, Column1 (Active Row)
Sheet2 C14 = Sheet1, Column2 (Active Row)
Sheet2 C15 = Sheet1, Column3 (Active Row)
Sheet2 C16 = Sheet1, Column4 (Active Row)
Sheet2 E12 = Sheet1, Column5 (Active Row)
Sheet2 E14 = Sheet1, Column6 (Active Row)
Sheet2 E15 = Sheet1, Column7 (Active Row)
Sheet2 E16 = Sheet1, Column8 (Active Row)

Hopefully this makes sense and thank you if you have kept reading.. My vision is to allow me to create a Final Test report from any row I choose from a push of a button.
I can figure out how to copy & past the entire row but I am not advanced enough in VBA to figure out something so specific.

I appreciate all suggestions.

Thanks
-CM

Hi JB,

Couldn't get your suggestion to work. It is more than likely something I am doing wrong. I am very new to VBA.
Thank you for replying.

Here is what I came up with..

Please Login or Register  to view this content.

Not sure is this most efficient method or cleanest coding practice but it accomplishes what I need it to do. If you see something completely wrong from what I did please let me know.

The next thing I would like to accomplish is being able to highlight multiple rows and it would copy & paste on Sheet2 then print, row by row.
Probably need to start a new thread.

-CM