Sorting Data by Priority

  • Thread starter Thread starter sryan
  • Start date Start date
S

sryan

I am setting up a excel databse that will track computer problems. On
sheet 1 I have a User Input Sheet where the user can input their name,
the date, description and priority of problem (priority eg: 1: Urgent,
2: can wait for a few days, 4: Nuisance and fixed sometime). I have a
process macro on sheet 1 which transfers all the user's inputted data
into Sheet Two. I want to sort sheet 2 by the Priority of the problems.
Is there any way I can do this without having to select the sheet and
having to go to data and Sort? I have sheet 2 linked to Access.

Any help with this would be really appreciated. Thanks
 
I don't know anything about Access, but if it were just excel, I'd record a
macro when I did it one time.

then I'd run that macro whenever I wanted the data sorted.
 
How is sheet 2 linked to Access? If you are using a SQL query add an
ORDER BY clause e.g.

SELECT Name, Date, Description, Priority
FROM MyTable
ORDER BY Priority DESC

If you are using MS Query you can do this from the menu by choosing:
Records, Sort.
 
Back
Top