Copy rows to existing sheet by any value in E to Done sheet
I've been working on this for weeks with no luck. I need a macro that when you click a button or rectangle will copy any rows that have a value in the E column to the Done sheet, the first empy row. It needs to work with any active sheet name. and it needs to copy to the bottom of the Done sheet.
Daily Shop Planner Work Order Log Master xlsx.xlsm
Sorry you spent weeks on this, just need a couple of lines of code. I think your example is suggesting copying shaded yellow cells? Not sure really, but this code works for cells in column E that have a value in them, as your post above suggests.
This code is meant for an ActiveX button.
Also, please note in your example file, the Done sheet is actually named "Done " (with a space after). So you need to fix that, or adjust the code if you expect it to run w/o error.
Please Login or Register to view this content.
Last edited by walruseggman; 10-06-2015 at 05:11 PM.
I'm interested in starting a career working with VBA, if anyone knows of any opportunities!
Thank you, it works but it's pulling it from all sheets. I need it to only pull from the active sheet to the done sheet. The intention is at the end of the day to just click and have that days completed rows on only the active sheet to be moved to the Done sheet. I had to remove .specialcells(2) in the last line for it to work. So what do I add to make only pull from the active sheet?
That's fine to do, but it means it will copy every row from E2 to the last row in E. You had mentioned you only wanted the rows copied that had values in E, which is what SpecialCells(2) does.I had to remove .specialcells(2)
Anyway, to modify for just the active sheet:
Please Login or Register to view this content.
Works, with a little tweaking. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks