Hi All

I have exported a file from our main system at work and require and need to pull it into Excel 2007 to create Pivot Tables for every department.

I can do everything that i said above the problem is with the data that is exported.

Let me start in saying that the data has to do with time sheets when people logged in and out at work. Now if the person do not log in or out the system gives the following value in its excel form --- which screws my formulas and pivot tables i have created.

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.