Hi,
I am a novice with macros beyond recording them and am hoping someone can help me tweak mine.

I am simply trying to copy column "G" and paste its values into the next empty column. This way when new data is entered I can store the data's history.
Below is where I currently stand and I am attaching the file if that will help.
Imports.xlsm

Sub Macro2()
'
' Macro2 Macro
'
' Keyboard Shortcut: Ctrl+l
'
Columns("G:G").Select
Range("G4").Activate
Selection.Copy
Columns("BK:BK").Select
Range("BK4").Activate
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("BK4").Select
Application.CutCopyMode = False
Selection.ClearContents
End Sub