I'm trying to figure out the code for copying selected cells from one sheet to an empty row in another sheet, this is what I have so far, but I cannot figure out how to make it so that it copys in next empty row, rather than replacing whats there
Range("A24:G24").Select
Selection.Copy
Sheets("Master Data").Select
Range("A5").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
So I want the code to find the next empty row after A5, even if it gets to a50. I know this is possible as a previous spreadsheet of mine did that, but it's been a few years and I've forgotten, and no longer have that spreadsheet
Range("A24:G24").Select
Selection.Copy
Sheets("Master Data").Select
Range("A5").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
So I want the code to find the next empty row after A5, even if it gets to a50. I know this is possible as a previous spreadsheet of mine did that, but it's been a few years and I've forgotten, and no longer have that spreadsheet