Name lookup

Hi all,

I have been playing around with this for a bit and now have it sorted out. This is a macro that will check a name list and highlight any cell that contains one or more of the names.

Since writing it I found it quite usefull.

Please Login or Register  to view this content.

All you have to do is create a tab called "name list" and list all the names you are looking for in the Column A. Then on Sheet 1 column A have the data you are looking through.

Hope this helps.

Ya, I figured it out. Just wanted to post incase someone was looking for it. Sorry new here.