SandsB
Well-known Member
- Joined
- Feb 13, 2007
- Messages
- 705
- Office Version
- 365
- Platform
- Windows
I have a macro that ends with a file containing nothing but rows of data to be copied, as is, after the last row of data already in another file. If the number of rows of data to be copied were the same every time I might be able to fiddle with this until it works. What code could I add to my macro that says:
Copy all non-blank rows in the file I'm currently working in and paste that data after the last row of data in FileB.xlsx. Assume FileB.xlsx is already open.
Thanks guys
Copy all non-blank rows in the file I'm currently working in and paste that data after the last row of data in FileB.xlsx. Assume FileB.xlsx is already open.
Thanks guys