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?

[JieJenn]

Edit: Removed due to I need to learn how to read.

[JieJenn]

Ignored my last post use this one. Didn't notice you were looking for description

Please Login or Register  to view this content.

[rs1aj]

This is very close. It changes all the date values in column E to the max date for each part number.

I actually need the description in column B to change, not the dates in column E. I want the vba code to only look for the max date in column E for each unique part number and once the "max date" is found, change the descriptions(column B) on all the older dates to match the "max date" description.


Basically, I want all the part number on the sheet to have the most recent description for that part number. Example, back on 01/01/2014, part "Y" was called "butter", but in 03/01/2014, part "Y" was called "soft butter". I want the vba code to find the most recent name used for that part, "soft butter" and change the description of the 01/01/2014 line to "soft butter" instead of "butter".

I hope this makes since and thanks for your help on this.

[JieJenn]

Use the code I posted late. Don't use the file, the macro embedded within the file was incorrect.

[rs1aj]

Amazing! This is going to save me so much time.

Thank you!!