All the coding works great. Very Happy.
All the coding works great. Very Happy.
Last edited by catnam; 11-13-2015 at 05:37 PM. Reason: Solved
Is it necessary to select a row with "Transfer" in column H? Why not have the macro automatically copy and paste all the rows that have "Transfer" in column H without having to select a cell?
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Yes it is. Because in the Debt 1 register, there will be previously transferred rows. I only want the transfer the newest entry. Thanks
Maybe:
Please Login or Register to view this content.
Thanks John, this is working great, however, for some reason the message boxes are not showing, when I make selections, that should make them show. Correction, "Wrong Row" does show when I click outside the rows, but if I select "Payment" no message show.
Last edited by catnam; 11-13-2015 at 04:59 PM.
Assign this macro to both buttons:Please Login or Register to view this content.
Last edited by Mumps1; 11-13-2015 at 05:15 PM.
@Mumps1, your code works great and took care all the exceptions expressed by the message boxes, I really appreciate your expertise.
@John, I appreciate your expertise too. It's amazing how two approaches can accomplish the same thing.
Have a great day!!!
Glad to help.
@Mumps1, your code works great and took care all the exceptions expressed by the message boxes, I really appreciate you expertise.
@John, I appreciate your epertise too. It's amazing how two approaches can accomplish the same thing.
Have a great day!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks