UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Sovled.::::::::::::::::Auto Sort Entries after data is entered    
 
   
ajames420
post Aug 27 2007, 08:02 AM
Post #1

UtterAccess Veteran
Posts: 473
From: Milwaukee, WI Area
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.
Go to the top of the page
 
+
fkegley
post Aug 27 2007, 08:38 AM
Post #2

UtterAccess VIP
Posts: 23,583
From: Mississippi
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.
Go to the top of the page
 
+
ajames420
post Aug 27 2007, 08:50 AM
Post #3

UtterAccess Veteran
Posts: 473
From: Milwaukee, WI Area
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
Go to the top of the page
 
+
fkegley
post Aug 27 2007, 09:16 AM
Post #4

UtterAccess VIP
Posts: 23,583
From: Mississippi
Yes, that would be another way to do it. Glad you got it!
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 06:32 PM