I have to create an automatic push from one workbook as a column to another workbook as a row. The second book is our overall blotter so the data needs to go to the bottom of the sheet. I have tried several different methods to get it to paste to the next available row, but always come up with errors. anyone have any ideas.
![]()
Sub Push() Sheets("DaY").Range("B1:M38").Copy Workbooks("BLOTTER.xlsm").Sheets("Blotter").Range("A2").PasteSpecial Transpose:=True End Sub
Bookmarks