Plumpychunks
New Member
- Joined
- Mar 1, 2018
- Messages
- 2
Hi,
Please help.
I have a sheet of data that is outputted from an external source, see below:
<tbody>
</tbody>
I would like some VBA to extract the rows that contain the earliest and latest date when columns A,B,C,D,E,G & H are all the same.
I can find methods to extract earliest and latest dates but none that can do it based 7 criteria.
All help would be greatly appreciated.
Please help.
I have a sheet of data that is outputted from an external source, see below:
Vehicle Reg | AxleType | Axle | Position | Dimension | New/Retread | Brand | Pattern | Event | Mileage | OTD | Date | RTD | Removal | Regrooved |
abc123 | Drive | 3 | L | 295/80R22.5 | New | GOODYEAR | KMAX | Fitment | 10 | 24 | 1.1.2016 | 24 | 3 | N |
abc123 | Drive | 3 | L | 295/80R22.5 | New | GOODYEAR | KMAX | Exam | 120000 | 24 | 31.12.2017 | 6 | 3 | N |
abc123 | Drive | 3 | L | 295/80R22.5 | New | GOODYEAR | KMAX | Removal | 123321 | 24 | 1.1.2018 | 4 | 3 | N |
789zyx | Carry | 3 | R | 385/65R22.5 | New | PIRELLI | AA1 | Fitment | 10 | 22 | 1.1.2012 | 22 | 3 | N |
<tbody>
</tbody>
I would like some VBA to extract the rows that contain the earliest and latest date when columns A,B,C,D,E,G & H are all the same.
I can find methods to extract earliest and latest dates but none that can do it based 7 criteria.
All help would be greatly appreciated.