Comparing Sheets - copy if found

[MrMcLee]

I have a macro that compares names on two worksheets(LastMonth and ThisMonth) and highlights the new names on ThisMonth. If it finds a name, I would like it to take the value from column E in LastMonth and put it in E for ThisMonth. I think I have a logic error, in that I don't think it accounts for a row that gets skipped. Thanks for looking.

Please Login or Register  to view this content.

[MrMcLee]

Got it on my own. Might not be perfect, but it works.

Please Login or Register  to view this content.