This WORKED PERFECTLY!!! You are an absolute Genius!!! Thank you! Thank
you! Thank you!!!

I couldn't find a way to make it work with my header row, so I just cut and
pasted my header row to the end of the sheet and when I was done, just cut
and pasted them back to the top row. Other than that, I just filled in the
name of my "Sheet1" tab and presto!!!! Thanks again!!! You have just saved
me and my boss and my company hours of labor.

"fiero84" wrote:

I do several reports everyday that require me to put a blank row between part
numbers that are different.

So, I'd like a Macro that would compare two cells, if they are equal to each
other, do nothing but keep moving down the list and comparing. If the cells
are different, one part number might be 100200 and the other part number
might be 655422, then put a blank row between those two parts and move on to
compare the rest of the list.

I'm pretty good with Excel and formulas - just new to working with Macros -
but am finding out they are pretty similar... just not sure of the correct
commands...

All I need is to see an example...

Many Thanks!!! :)