Copy cell with MAX date and past in older dates

[rs1aj]

I mainly need this for pivot table sales tracking.

I have part numbers that over the years, the descriptions have changed. Someone might have added a comma or space or whatever. When I put it in a pivot table and pull in "Part" and "Description" in the "Row Labels", the result will display the part number once, and list on separate lines all the different descriptions of that same part number. This causes problems.


On the data sheet, I'd like the vba code to look for the "max" date for each part number, and copy the description field and change all the older dates of that same part number to match the description of the max date part. Can this be done?