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,
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,