Hello,
This is my first post and also my first issue. Yippee! I am trying to create a way to automatically transfer data from one workbook to another. The source workbook has more data than I need in the end workbook. So, I am trying to be selective. I need this to be able to take the data below the row selected on workbook 1 and put it below the row selected on workbook 2. These sheets will end up being pretty large and a seamless addition of the data would make life much easier. I also have workbook 1 in a PDF form if there is an easy way to do this from a PDF form. I have started with the Macros and used the recorder to come up with this for the code.
When I try to run the macro I get a run-time error '1004' and ActiveCell.Offset(-4, -6).Range("A1").Select is highlighted in the debugger.Please Login or Register to view this content.
Any help would be appreciated.
Thank you,
John Petry
Bookmarks