Already have a Sorting Macro button on "Current Job List" sheet. Just wondering if it's possible to have it work automatically without clicking the button when a new row is transferred over from the other two sheets "3 Digit" & "4 Digit" worksheets?
See Example Below:
Why not just have the macro you are using to move those rows, call the sort macro as a final step?
Something like:
Please Login or Register to view this content.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Originally Posted by GeneralDisarray
Why not just have the macro you are using to move those rows, call the sort macro as a final step?
Something like:
Please Login or Register to view this content.
Not sure where to put this to make it work automatically?
Anybody else out there that can help me with this?
right click on tab (4 digit and 3 digit)
view code
at the end of the Worksheet_SelectionChange macro
you can
call sort_macro
then record yourself a sort macro to go to the sheet and sort it, and call it sort_macro.
Last edited by scottiex; 10-01-2014 at 02:17 PM.
Hi Elmer
Change your sortie Code to thisAdd this line of Code to each Worksheet Selection Change Event...add the line just before End SubPlease Login or Register to view this content.Get rid of the Sort Button.Please Login or Register to view this content.
If you need the whole File let me know.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks