sorting columns by date

[acm]

Hello,

I know this is an easy question but was hoping to get some help because it's taking me too long to figure out. I was looking to sort severy columns by depart date with the most current date showing at the bottom. Each row will contain information associated with these to dates, for example, trip expenses. The rows are entered by the end user and are sometimes put in after the fact and don't always sort chornologically. Therfore, what is the best way to format this sheet so the dates and the other associated information in others cells surrounding these dates properly stays together in the the row....each row is a record. I don't want to the user to sort every time using the A-Z sort. Should I build a MACRO or does 2007 have a feature you can autosort columns somwhere?

Also, do you recommend I build a form to accomodate data entry?

Thanks in advance,

 

[Datsmart]

Take a look at using a UserForm for data entry.
Good step by step instructions and an example download here:
http://www.contextures.com/xlUserForm01.html

This link includes a Listbox example:
http://www.contextures.com/xlUserForm02.html

Another link here: (more for DataBase)
http://www.tushar-mehta.com/excel/newsgroups/rdbms_in_excel/index.html

 

[acm]

Thanks...looks like I'll have some fun creating today. How do I solve my formatting issue so the dates will always be sorted no matter when the end user enters the data?

 

[Datsmart]

How do I solve my formatting issue so the dates will always be sorted no matter when the end user enters the data?

Sorting a table of data has nothing to do with Formatting, it is just Sorting.

To Sort a range of cells using code:

Sub SortRange()
    Range("A1").Sort Key1:=Range("B2"), Order1:=xlAscending, Header:=xlGuess
End Sub

This code assumes your data starts in cell A1 and your dates are in column B.