I am new to the forumn and would say i lack vb skills. I am trying to copy 8 cells B4:B8, C33:C36 from my Data Input worksheet to "Data Tracking Worksheet". The end user would use the Data Input sheet to update and select the Macro in order to copy and paste data to Data Tracking worksheet without overwritting past data. How do I go about resolving this macro without overwritting?

Here's my current Macro:



'
Range("B4:B8").Select
Selection.Copy
Sheets("Data Tracking").Select
Range("B2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
Sheets("Data Input").Select
Range("C33:C36").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Data Tracking").Select
Range("G2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
Sheets("Data Input").Select
End Sub