Can the blanks be deleted before copying? If not, no problem.
No 2 and No 3 contradict each other. Forget about them and just call it "to the first empty cell/row in Sheet1, wb2"
If there is data in Sheet1, wb2, are all the columns the same length?
By the looks of it, the 2nd workbook is closed and need to be opened.
Where is the 2nd Workbook saved? Don't need the path but makes things easier (for me anyway)
In the meantime, how far do you get with this? (Need to delete the empties yet.)
I don't know if it works if you insert
before
Bookmarks