I have a macro that someone gave to me and it almost does what I need. I have two workbooks, Data Entry and Log Entry. I am trying to get the macro to copy from Data Entry A4:AG20 and paste into Log Entry on the next available blank row BELOW any existing rows that have data. All the column headings are the same in the two workbooks.
This macro will just add a row to the top or overwrite any data I have already. Can you please help?
Thank you in advance. Here's the existing macr (it is in Log Entry):
Windows("BDataEntry.xls").Activate
Range("A4:AG8").Select
Selection.Copy
Windows("BLogbook.XLS").Activate
Selection.PasteSpecial Paste:=xlAll, Operation:=xlNone, SkipBlanks:=True _
, Transpose:=False
End Sub
This macro will just add a row to the top or overwrite any data I have already. Can you please help?
Thank you in advance. Here's the existing macr (it is in Log Entry):
Windows("BDataEntry.xls").Activate
Range("A4:AG8").Select
Selection.Copy
Windows("BLogbook.XLS").Activate
Selection.PasteSpecial Paste:=xlAll, Operation:=xlNone, SkipBlanks:=True _
, Transpose:=False
End Sub