Sort - Blank Cell

[jbridge9194]

Hi,

I want to create a macro that sorts each row by date based on one column unless the content of that column is blank and it would then refer to another column e.g.

Job Number Requested Launch Date Agreed Launch Date
Job 1 12/08/2010
Job 2 01/08/2010 01/08/2010
Job 3 24/08/2010 31/08/2010
Job 4 17/08/2010
Job 5 11/08/2010 11/08/2010

Based upon the sort I want to do the jobs would be rearranged into the following order:

Job Number Requested Launch Date Agreed Launch Date
Job 5 11/08/2010 11/08/2010
Job 1 12/08/2010
Job 2 01/08/2010 13/08/2010
Job 4 17/08/2010
Job 3 04/08/2010 31/08/2010

Hope this makes sense, any assistance would be appreciated

Cheers
Jason