Sorting Data by Date

**Dragonruler12** · 12-01-2008, 05:14 PM

I have a Column J with Dates formated in the dd/mm/yyyy format how do I used the Selection.Sort key:= xx order:= to sort the rows that have a date in the selected columns. Where J_End in the code below is the Column I need to refer to its sorting to a point but im not sure whats wrong with it.

All I really need it to do is group all the ones with a date (completed) and without a date (not completed) thus why im sorting it and the other stuff prioritize it.

Please Login or Register  to view this content.

**Leith Ross** · 12-01-2008, 07:02 PM

Hello Dragonruler12,

If you attach your workbook you will receive an answer faster. If your are using Excel 2007 then you should save the workbook in Excel 2003 format as more people are running this version of Excel.

Sincerely,
Leith Ross

**Dragonruler12** · 12-02-2008, 09:38 AM

ok dookey as requested is the attached excel spreadsheet im using. Look at any tab with the gateway macro. It is under that and sort and then sort completed to top, you can see the column that says completed too.

**Dragonruler12** · 12-02-2008, 10:15 AM

Nevermind I solved my problem... Like I said it was in my sort I just must have done something stupid in order to sort date in a column this is what I used. And "Comp" is K8 wherever the range is you want to start. It brings dates up to the top.

Please Login or Register  to view this content.

Sorting Data by Date

LinkBack

Thread Tools

Rate This Thread

Display

Sorting Data by Date

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions