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.
[TABLE="width: 512"]
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Batch No[/TD]
[TD="width: 64"]Make[/TD]
[TD="width: 64"]Model[/TD]
[TD="width: 64"]17 Digit Chassis No[/TD]
[TD="width: 64"]Registration Date
(DD/MM/YYYY)[/TD]
[TD="width: 64"]Stock Number[/TD]
[TD="width: 64"]Branch[/TD]
[TD="width: 64"]Purch/Add Date[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036106[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208692[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036125[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208693[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036207[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208708[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036210[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208684[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036245[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208690[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036411[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208689[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036412[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208705[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036435[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208699[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036537[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208698[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036602[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208685[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036616[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208707[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036626[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208704[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036635[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208706[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036653[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208697[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036742[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208703[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036759[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208753[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036812[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208741[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036844[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208686[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036863[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208754[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036864[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208747[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036887[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208701[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036995[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208696[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037055[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208702[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037060[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208695[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037061[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208700[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037070[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208742[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037093[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208761[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037097[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208764[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037119[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208687[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037258[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208680[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037277[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208743[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037341[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208745[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037359[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208734[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037370[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208752[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037592[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208677[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037638[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208759[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037679[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208736[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037751[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208756[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037774[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208739[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037819[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208762[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037839[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208788[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037869[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208740[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037890[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208749[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037926[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208744[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036995[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]8415[/TD]
[TD]FE[/TD]
[TD]28/06/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037060[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]8414[/TD]
[TD]FE[/TD]
[TD]28/06/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037341[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]3190[/TD]
[TD]FS[/TD]
[TD]28/06/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037097[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]4390[/TD]
[TD]GB[/TD]
[TD]28/06/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036602[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]12601[/TD]
[TD]GU[/TD]
[TD]28/06/2019[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 512"]
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Batch No[/TD]
[TD="width: 64"]Make[/TD]
[TD="width: 64"]Model[/TD]
[TD="width: 64"]17 Digit Chassis No[/TD]
[TD="width: 64"]Registration Date
(DD/MM/YYYY)[/TD]
[TD="width: 64"]Stock Number[/TD]
[TD="width: 64"]Branch[/TD]
[TD="width: 64"]Purch/Add Date[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036106[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208692[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036125[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208693[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036207[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208708[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036210[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208684[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036245[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208690[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036411[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208689[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036412[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208705[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036435[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208699[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036537[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208698[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036602[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208685[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036616[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208707[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036626[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208704[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036635[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208706[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036653[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208697[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036742[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208703[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036759[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208753[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036812[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208741[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036844[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208686[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036863[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208754[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036864[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208747[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036887[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208701[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036995[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208696[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037055[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208702[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037060[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208695[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037061[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208700[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037070[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208742[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037093[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208761[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037097[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208764[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037119[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208687[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037258[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208680[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037277[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208743[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037341[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208745[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037359[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208734[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037370[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208752[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037592[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208677[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037638[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208759[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037679[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208736[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037751[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208756[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037774[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208739[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037819[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208762[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037839[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208788[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037869[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208740[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037890[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208749[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037926[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]208744[/TD]
[TD]AU[/TD]
[TD]23/04/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036995[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]8415[/TD]
[TD]FE[/TD]
[TD]28/06/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037060[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]8414[/TD]
[TD]FE[/TD]
[TD]28/06/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037341[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]3190[/TD]
[TD]FS[/TD]
[TD]28/06/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6037097[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]4390[/TD]
[TD]GB[/TD]
[TD]28/06/2019[/TD]
[/TR]
[TR]
[TD]VX65[/TD]
[TD]Vauxhall[/TD]
[TD]Vauxhall Adam Hatchback Special Ed 1.2i Energised 3dr[/TD]
[TD]W0V0MAP08K6036602[/TD]
[TD]30/05/2019[/TD]
[TD="align: right"]12601[/TD]
[TD]GU[/TD]
[TD]28/06/2019[/TD]
[/TR]
</tbody>[/TABLE]
Thanks
Dave
