Aug 27 2007, 08:02 AM
Does anybody know if there is a way to auto sort entries on a spreadsheet after data is entered from a user form?
I have users enter Hub name, CSR, Customer, Date, Pkg Quantity.
After they enter the data I would like to sort by Hub Name and Date.
Is this possible?
Edited by: ajames420 on Mon Aug 27 9:36:03 EDT 2007.
Aug 27 2007, 08:38 AM
You might be able to do this by placing come code under control of the Worksheet Change event. You would need to test the column value of the Target range being passed to the event, if it is the last column in the list, then you could sort the worksheet.
Aug 27 2007, 08:50 AM
What I did was record a macro then called the macro (MacroSort) when a button is pressed to append all the data to the workbook.
Aug 27 2007, 09:16 AM
Yes, that would be another way to do it. Glad you got it!
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here