Macro to Paste Values from static range to last empty row in worksheet

[dfriedholm]

Macro assistance Request:
I have summary range B1:F1 in a worksheet (Summary) containing values which update from another worksheet (Sheet1) in the same workbook. I need a user-triggered macro which will copy and paste the VALUES of each cell in the summary range into the first empty corresponding cells in a table below... example copy values from B1:F1 to B16:F16. The next time the macro is triggered, the updated summary values would paste from B1:F1 to B17:F17 etc.

I've searched the forum without success.
Any help would be greatly appreciated........

Thanks in advance.
Under the gun...............

 

[venkat1926]

NOT CLEAR. you mean that every time B1:F1 should be copied in the last row plus one in the same worksheet (summary).
ONCE you copy the B1:F1 and paste it to B16

subsequently you can uses this macro

Sub test()
With Worksheets("summary")

.Range("B1:F1").Copy

.Cells(Rows.Count, "b").End(xlUp).Offset(1, 0).PasteSpecial
End With
End Sub

this means every time the B1:F1 is refreshed you have to invoke this macro. If you wnt this to be done automatically you have to have an event code for the sheet.