Mar 14, 2008 #1 hdat44 Technical User Aug 15, 2002 50 GB Hi I know that you can sort a date in a column by using the data - sort by function but is there any way that this can happen automatically?
Hi I know that you can sort a date in a column by using the data - sort by function but is there any way that this can happen automatically?
Mar 14, 2008 #2 AnotherHiggins Technical User Nov 25, 2003 6,259 US Well, there's a button on the toolbar that's quicker. But excel doesn't do things you don't tell it to. You could use a macro to re-sort every time you enter a new record. If you want to explore that option, please post a new thread in forum707. [tt]_____ [blue]-John[/blue][/tt] [tab][red]The plural of anecdote is not data[/red] Help us help you. Please read FAQ 181-2886 before posting. Upvote 0 Downvote
Well, there's a button on the toolbar that's quicker. But excel doesn't do things you don't tell it to. You could use a macro to re-sort every time you enter a new record. If you want to explore that option, please post a new thread in forum707. [tt]_____ [blue]-John[/blue][/tt] [tab][red]The plural of anecdote is not data[/red] Help us help you. Please read FAQ 181-2886 before posting.