Hello Everybody,

Does anybody know how to make a macro that will start on A1 and I1 and take those values and see if there are duplicates below it. If A1 equals any value found below it it will then check I1 and see if it has the same value. If it does then it will delete the duplicate row and continue until it comes across and empty row. Once it comes across an empty row it will then proceed onto A2 and I2 and run the same check to see if it finds duplicates. Once the program come across and empty row it will stop completely. Any help is appreciated.