Hi All, Looking for some help with a VBA code.
Each day I get a data download from one of our systems which compiles all completed, ongoing and cancelled cases.
I then have to manually go through the data to sort into 3 new sheets within the same workbook. With over 20,000 of data each day this can be quite mind numbing and slow.
I would like a code which will look at the status column (D) and depending on the column value, automatically move that whole row to a new sheet.
An example of my data is below
<colgroup><col span="4"></colgroup><tbody>
</tbody>
So I would like the code to look and the status column and sort the data as:
Where status = Complete - Move to Completed Sheet
Where Status = Awaiting Payment OR On hold - Move to Ongoing Sheet
Where Status = Cancelled - Move to Cancelled Sheet
Thanks in advance
Ben
Each day I get a data download from one of our systems which compiles all completed, ongoing and cancelled cases.
I then have to manually go through the data to sort into 3 new sheets within the same workbook. With over 20,000 of data each day this can be quite mind numbing and slow.
I would like a code which will look at the status column (D) and depending on the column value, automatically move that whole row to a new sheet.
An example of my data is below
Name | Date input | Amount | Status |
John | 01/09/2016 | £0 | Awaiting Payment |
Steve | 10/09/2016 | £0 | On hold |
Andy | 11/09/2016 | £0 | Awaiting payment |
Sam | 20/09/2016 | £1,000 | Complete |
Sally | 10/10/2016 | £500 | Complete |
Charlotte | 15/10/2016 | £0 | Cancelled |
<colgroup><col span="4"></colgroup><tbody>
</tbody>
So I would like the code to look and the status column and sort the data as:
Where status = Complete - Move to Completed Sheet
Where Status = Awaiting Payment OR On hold - Move to Ongoing Sheet
Where Status = Cancelled - Move to Cancelled Sheet
Thanks in advance
Ben