I'm learning VBA and I've been at it a couple of weeks. I've managed to make this monstrosity of a code somewhat work for me.
If a employee types their initials into column R and presses enter. that row will change to calibrated and it will get copied to a log from Column N:S
The problem I have is my coding skills aren't upto par, not everyone presses enter when they type their initals, some press tab or click off the cell so my reference to ActiveCell.Row is the weak link in the chain
Any help or guidance would be apperciated!
Set BG = Range("N" & ActiveCell.Row) Set EN = Range("S" & ActiveCell.Row) Set SERange = Range(BG, EN).Offset(-1, 0) Dim sh As Worksheet: Set sh = Sheets("Log") Application.EnableEvents = False Application.ScreenUpdating = False SERange.Copy lastRow = sh.Range("a1048576").End(xlUp).Row sh.Range("A" & lastRow + 1).PasteSpecial xlPasteValues Application.CutCopyMode = False Application.ScreenUpdating = True