Help please !!! I have a excel work book with the following sheets , E-1 and Overdue.

The E-1 sheet consist of over a 1000 rows. I have a lot of formulas on that sheet to make certain items in colour and so on.

I need a formula or VBA help to get only the overdue orders on the E-1 sheet and copy them to the overdue sheet.

If the column AC is between -1 and -1000 it should copy that row to the overdue sheet.

If this formula is possible can we put in that column AC should be sorted from Highest to lowest.