Basic copy paste macro not working

[geeman86]

Hello,

referring to the spreadsheet attached. I am inputting basic data in column C3:C9, and outputting that data in row B14:F14.
I tried to create a macro that once I hit copy paste values (I want to copy paste special i.e. values), I want to copy the output data into a new row.

Then as I change the inputs, employee name, hourly rate etc, the table output will update, so then I want to then hit the copy paste values macro to then paste the new information in another row below the previously pasted data.

Hope that makes sense, thanks in advance.
-G

[Marc L]

According to your attachment a VBA demonstration for starters :

Sub Demo1()
    Rows(Application.Max(Cells(Rows.Count, 2).End(xlUp)(2).Row, 18)).Columns("B:F") = [B14:F14].Value
End Sub 

► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

[geeman86]

Thank you Marc, that works!