Hi There,
I am looking for a macro to sort a whole sheet on one column in order A-Z then to remove lines if data in that column has duplicate information in it but then i would like it to remove the later entry or entries based on a date.
So the column i want it to sort on is Column D "17 Digit Chassis No" then leave only the earliest dated record based on the date in Column H "Purch/Add Date".
I have tried to decipher other macros on here to suit my criteria but i have failed miserably each time, but you cant blame a guy for trying!!
Could anyone assist please?
SAMPLE DATA BELOW (Cant seem to get it into a table on the forum, im obviously missing something.
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
Thanks
Dave
I am looking for a macro to sort a whole sheet on one column in order A-Z then to remove lines if data in that column has duplicate information in it but then i would like it to remove the later entry or entries based on a date.
So the column i want it to sort on is Column D "17 Digit Chassis No" then leave only the earliest dated record based on the date in Column H "Purch/Add Date".
I have tried to decipher other macros on here to suit my criteria but i have failed miserably each time, but you cant blame a guy for trying!!
Could anyone assist please?
SAMPLE DATA BELOW (Cant seem to get it into a table on the forum, im obviously missing something.
Batch No | Make | Model | 17 Digit Chassis No | Registration Date (DD/MM/YYYY) | Stock Number | Branch | Purch/Add Date |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036106 | 30/05/2019 | 208692 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036125 | 30/05/2019 | 208693 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036207 | 30/05/2019 | 208708 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036210 | 30/05/2019 | 208684 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036245 | 30/05/2019 | 208690 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036411 | 30/05/2019 | 208689 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036412 | 30/05/2019 | 208705 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036435 | 30/05/2019 | 208699 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036537 | 30/05/2019 | 208698 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036602 | 30/05/2019 | 208685 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036616 | 30/05/2019 | 208707 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036626 | 30/05/2019 | 208704 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036635 | 30/05/2019 | 208706 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036653 | 30/05/2019 | 208697 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036742 | 30/05/2019 | 208703 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036759 | 30/05/2019 | 208753 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036812 | 30/05/2019 | 208741 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036844 | 30/05/2019 | 208686 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036863 | 30/05/2019 | 208754 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036864 | 30/05/2019 | 208747 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036887 | 30/05/2019 | 208701 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036995 | 30/05/2019 | 208696 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037055 | 30/05/2019 | 208702 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037060 | 30/05/2019 | 208695 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037061 | 30/05/2019 | 208700 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037070 | 30/05/2019 | 208742 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037093 | 30/05/2019 | 208761 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037097 | 30/05/2019 | 208764 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037119 | 30/05/2019 | 208687 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037258 | 30/05/2019 | 208680 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037277 | 30/05/2019 | 208743 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037341 | 30/05/2019 | 208745 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037359 | 30/05/2019 | 208734 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037370 | 30/05/2019 | 208752 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037592 | 30/05/2019 | 208677 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037638 | 30/05/2019 | 208759 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037679 | 30/05/2019 | 208736 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037751 | 30/05/2019 | 208756 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037774 | 30/05/2019 | 208739 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037819 | 30/05/2019 | 208762 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037839 | 30/05/2019 | 208788 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037869 | 30/05/2019 | 208740 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037890 | 30/05/2019 | 208749 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037926 | 30/05/2019 | 208744 | AU | 23/04/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036995 | 30/05/2019 | 8415 | FE | 28/06/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037060 | 30/05/2019 | 8414 | FE | 28/06/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037341 | 30/05/2019 | 3190 | FS | 28/06/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6037097 | 30/05/2019 | 4390 | GB | 28/06/2019 |
VX65 | Vauxhall | Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr | W0V0MAP08K6036602 | 30/05/2019 | 12601 | GU | 28/06/2019 |
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
Thanks
Dave