Sort ascending

Hello;

I have an external query and want to sort by schedule date - only problem is there are some items without a start date and these pull up first - I'd like see first the ones with a date, then follow with those without. Is there a way to do it? Thanks for any help!

Hi

If you select the whole range and sort descending, then select only the range with dates e.g. on the date column find last row with a value

Range("A65536").end(xlup).row

and then sort ascendng,

Regards

Jeff

uuh.. i'm sorry, you lost me. i'm not sure how to enter in the code, and this would work each time i hit refresh?

Hi

It is possible to add code to an individual worksheet that will run each time the worksheet changes, this is the "WorksheetChange" event. Rather than trying to explain, if you post a sample of your data I will add the code you need and you can see how it works.

Regards

Jeff