Find and Copy ONLY Last full Row to Different Workbook Sheet

[Techno16]

This copies last row and everything above it but I only want to capture the last row; how do I fix this (or if there's another method altogether, I'm good w/ that too!)

Need help knowing how to paste it into Sheet 2 of a different workbook too as this only puts it into Sheet2 of same workbook.
Other workbook would be found here: c:/users/me/Documents/Reports/MasterReport.xlsm (Sheet2)

I can either have both open at same time when I hit RUN or I can keep the MasterReport closed if that's easier -- whatever is easiest to script..

Please Login or Register  to view this content.

Thank you

[TMS]

For the first part, try:

Please Login or Register  to view this content.

For the second part, fully qualify the target range with the workbook reference ... easiest if the target workbook is open.

[Techno16]

TMS, thanks greatly! That first part works great! Grabs only the last full row as intended! Very happy!
As for the copying to another workbook, I'll have to try to figure out where/how to put that workbook reference -- not yet a vba pro

Chris

[jolivanes]

You could try this.

Please Login or Register  to view this content.

[Techno16]

Jolivanes , thank you for the help on adding workbook! very kool - but - had issues..
Ran it with wb1 open and wb2 closed (ran code from the wb1) and got the 1st error.
So, I changed the code to comment out the first one and use the 2nd line option, still got error.

Third, I opened wb1 and wb2 at same time, ran it again and it ran successfully, then it closed the wb2 out automatically however nothing was saved. Based on your notes, the way it sits now, it should save with "True" still in tact... but don't we need to add something to command it to both SAVE and CLOSE? Again, I'm not an expert but it seems like it only says: "Close=True" and seems like it needs both Save and Close

If we can get the saving part working I think we might be golden!?
(tried to attach pic but it said it would not let me until I've done a few other posts)
(tried to place a copy of the PICTURE into an excel file but won't allow me to upload that either! ARGH!)...


Here's the lower section of the code as it exists at this moment (where it runs successfully without turning anything yellow - but just doesn't save anything)

Please Login or Register  to view this content.

[jolivanes]

You don't show your whole code.
Is the path changed properly?
It does not say "Close =True"
It states "wb2.Close" and after that a space and then True. The "True" means to save it.

[jolivanes]

If both workbooks reside in the same folder, what does this do?
Make sure to change references like workbook names, sheet names and row references.

Please Login or Register  to view this content.