Help Copying Column to Newest Empty Column

[Emili Excel]

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

[Mumps1]

Try:

Please Login or Register  to view this content.

[Emili Excel]

Hey Mumps!

I tried pasting it in but for some reason all it ends up doing is adding a converting column "G" to a data table and adds a header (see below image)
It might have pasted it in wrong? But it is start for me though and I'm going to try and play around with it

Picture.png

[Emili Excel]

Wait! Actually it worked!

I think if I change the formatting for the date to mm-yy then I'm set on all fronts too.

Thank you so much!!!

[Mumps1]

My pleasure.