I have names in ranges A5:A104 and in Z6:Z105. The amount of names can be from 1 - 100 but won't go outside this range. I need a macro that will clear contents (not delete) of any cells in range A with names that are not found in range Z (clear unique names in range A). After this is done I want to clear any names in range Z that are found in range A (leaving only unique names in range Z). Thanks!
example:
range A --- range Z
bob ---- bob
tim ---- nate
josh --- bill
kevin -- josh
result:
range A ---- range Z
bob ----- (clear)
(clear) -- nate
josh ----- bill
(clear)-- (clear)
Bookmarks