• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

Sort data by Date based on 4 column worksheet (Excel 2003)


I have a worksheet in Excel 2003 that contains about 400 rows, (i have pasted 2 rowns below)

Colum 4 contains a date, i would like all data sorted by date order based upon this row, i was playing around myself however i managed to get column 4 in date order however colums 1 -3  never changed order so meant all my data was out of sync, can anybody tell me how to do it


Full Path                    Size                 Allocated            Last Change    

E:\Users\GriffithsD\      14969.5 MB      9414.4 MB      03/03/2011            
E:\Users\EllisD\       7806.9 MB      5838.3 MB      04/03/2011                        
1 Solution
Select your entire data set starting from column 1 till you last column. then go to menu Data--Sort. Excel will automatically assume your first row of the data set as column header, if not then check the check box that says so. Select your date column in the sort by box and select asc or desc. This should sort your entire data.
Here is some VBA code if you prefer to do it that way:
Sub sortdata()

    Selection.Sort Key1:=Range("D2"), Order1:=xlAscending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
End Sub

Open in new window

ncomperAuthor Commented:
Thanks all, doing it via data-sort worked perfect

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now