New to VBA. I have tried recording and tweaking this code but am starting to get diminishing returns on effort. The goal for this command button is to simply take data that is input into one sheet and put them in the very next blank row in another.
Code:
Private Sub btnsubmit_Click()
Sheets("Entry").Select
Range("C4:C8").Select
Selection.Copy
Sheets("Sheet3").Select
NextRow = Range("B" & Rows.Count).End(xlUp).Row + 1
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
Sheets("Entry").Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub
I imagine the main source of the problem starts at the Code line "NextRow" but do not have the experience or knowledge to fix it. Any guidance would be much appreciated.
Bookmarks