Full Version: Sovled.::::::::::::::::Auto Sort Entries after data is entered
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
ajames420
Does anybody know if there is a way to auto sort entries on a spreadsheet after data is entered from a user form?

Example:
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.
fkegley
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.
ajames420
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.

thank you
fkegley
Yes, that would be another way to do it. Glad you got it!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.