I am using this code to pull data from sheet3("G5"), when it inserts it goes beyond the page limits, any ideas on how to auto include starting a new line for the data?
If InStr(TextBox2.Value, " 5 ") Then
Dim lastRow As Long
lastRow = wsGroup.Cells(wsGroup.Rows.Count, "K").End(xlUp).Row + 1
wsGroup.Range("K" & lastRow + 1).Value = wsSheet3.Range("G5").Value
end if
I would upload a screen shot, but this seems beyond my current capabilities on this site
Any help or feedback appreciated,
Cheers,
Cmack
If InStr(TextBox2.Value, " 5 ") Then
Dim lastRow As Long
lastRow = wsGroup.Cells(wsGroup.Rows.Count, "K").End(xlUp).Row + 1
wsGroup.Range("K" & lastRow + 1).Value = wsSheet3.Range("G5").Value
end if
I would upload a screen shot, but this seems beyond my current capabilities on this site
Any help or feedback appreciated,
Cheers,
Cmack