Copy Row Range from one Workbook to Another?

[msgtgumby]

I've found a lot of code on doing this between sheets, not so much between workbooks. I have two workbooks that will be open. The first book will be where the code will run from and the data will be copied from, the second workbook just sits open in the background, the one that gets pasted to. I'd like to try and automate part of that if possible, usually I manually do it.

I would like any row starting at row 13 on the first sheet of the first workbook that contains "99" in column L to be copied (just range A to H of the row) to the next blank row of the second workbook (it already contains 10k+ items so it will always need to paste to the changing bottom blank row). Could anyone help with this?

Thanks,

Gum

 

[Joe4]

Re-posted: https://www.mrexcel.com/forum/excel-questions/986739-wont-paste-next-blank-row.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you not to bump a thread more than once a day.

I am locking this one and leaving the other open.