Is there a way to run Microsoft Excel Objects "sheet 1" Macro which copies designated row from sheet 1 to Sheet 3 then automatically runs Module 1 which is a sort Macro? (See codes below)
[/CODE]Please Login or Register to view this content.
Is there a way to run Microsoft Excel Objects "sheet 1" Macro which copies designated row from sheet 1 to Sheet 3 then automatically runs Module 1 which is a sort Macro? (See codes below)
[/CODE]Please Login or Register to view this content.
Last edited by ElmerFud; 09-13-2014 at 11:55 AM.
Where's the code that copies from Sheet1 to Sheet3?
If posting code please use code tags, see here.
you mean add
to the end of the selection change event?Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Well for some reason it hangs at in sheet 3 called "Current Job List".Sheet 1 called "3 Digit" has it's own automatic macro using Marlette "a" in column A to automatically copy row over to sheet 3 "Current Job List" which it has a button to click and sort the rows (see above code in first request). I'm just trying to figure out if there's a way to automatically have it sort without having to click the button each time a row from another sheet is copied over to the "Current Job List". I need to use both existing codes above to work together one after the other. Sorry if I'm rambling on not sure I'm getting my point across very well.Please Login or Register to view this content.
Last edited by ElmerFud; 09-13-2014 at 07:49 PM.
Can you upload an example workbook?
Click on GO ADVANCED and use the paperclip icon to open the upload window.
Duplicate post sorry!
Enclosed is an example of "Current Job List" that's working fine. I just would like it to copy the designated row over to the "Current Job List" then sort automatically rather than clicking on the "Sort" button. Also, if possible to recognize duplicates if the row has already been transferred.
Attachment 345275
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks