Delete duplicate rows

[lsr]

Please find the attached file of the report and i need to create a macro for the following change

Component 1004021(raw material) is used twice in other raw materials 1004105 and 1004025. But It should show only one record per material 1004105 and 1004025 based on the level or material.

In technical terms...

Step 1: When ever i find duplicate component (more than one record in column F)...Do a look up into column H to get the corresponding Material number (H34 or H35 or H41 or H42)
Step 2: Use the material we got from column H from the above step 1 and do a look up into column F to keep the matching number (row) in column F and delete the other row ( row 34 in first case)

Delete the row 42 from the second case...

[watersev]

hi, lsr, I've tried to open your attached file but I have got an error on opening: file damaged, Excel attempt to restore it has failed. Can you reupload it once again maybe in a different format (xls or xlsx)?

[lsr]

Hi,

I have uploaded the new version of the file in xlsx format. Please check it and let me know