Put the two lists one after each other on a new sheet. Then go to worksheet
menu

Data - Advancefilter

Select Unique Values Only and Copy to new range. This will give you unique
values. If you need a macro turn on the macro record while performing
operations.

"Cheffred" wrote:

I need a macro that can go down a spreadsheet and when it finds a certian
word to delete that row and the four rows below the first. Any suggestions?