VBA clear cell in table if not in list

[wannabeexcelguy]

Hi gurus,

Firstly thank you to anyone who responds, it's always appreciated.

I have a list of businesses in column A of Sheet2 and a table of records in columns C:Z in Sheet1.

Businesses listed in column A of Sheet2 can appear anywhere in the table in Sheet1, but a corresponding percentage is always in the cell directly to the right of the cell with their business name.

Is there VBA code that could clear the businesses names and the corresponding percentages (cells to the right) from the table in Sheet1 if the business does not appear in the list in Column A of Sheet2? Note: I want to clear the cells not delete them.

An example workbook is attached. Please let me know if I need to clarify anything!

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[PCI]

See next code

Please Login or Register  to view this content.

[wannabeexcelguy]

Amazing, works perfectly with a copy paste. Wish I had your skills. Thanks!!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback and the rep.

[PCI]

"Amazing, works perfectly with a copy paste"
You did what must be done to succeed quickly: you attached an example.

[TMS]

Late entry but, as I've done it, you might as well have it and test it.

Please Login or Register  to view this content.

Regards, TMS

[wannabeexcelguy]

Also works perfectly TMS! I really struck it lucky on this post with you three.

I have actually moved on to my next problem if you guys have the time/inclination to look at it, link below. Sorry if this is against forum rules?

http://www.excelforum.com/excel-prog...ml#post4137246

[TMS]

You're welcome. Thanks for the rep.

No, not against the rules. In fact, new question, new thread, exactly what we would hope for.

Regards, TMS