Solved problem.
Solved problem.
Last edited by Sameer_81; 08-16-2017 at 03:49 PM.
Something like this?
Edit: fixed an error at 11:19 amPlease Login or Register to view this content.
Last edited by danielexcelvba; 08-03-2017 at 11:19 AM.
Solved Problem.
Last edited by Sameer_81; 08-16-2017 at 03:49 PM.
What about this
Please Login or Register to view this content.
Solved Problem.
Last edited by Sameer_81; 08-16-2017 at 03:50 PM.
If your column "A" on that sheet is blank (and you didn't just delete the data for the screenshot) then that will be the issue, since the code scans column "A" to determine your last row. You can use this (uses column "B" instead)
Actually, that will only fix the issue of where it pastes. Could you also put a screenshot/upload a cpoy of where the data is coming from? You can black out anything sensitive.Please Login or Register to view this content.
Last edited by danielexcelvba; 08-03-2017 at 12:44 PM.
Solved Problem.
Last edited by Sameer_81; 08-16-2017 at 03:50 PM.
Ah so you would once again have to change (rows.count, 1) to (rows.count, 2) for the "lasta" variable this time - I can't edit the actual code as I only have my phone available right now. This (should) copy the last row from the analyst sheet. That's what you were going for right?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks