VBA Help: Linking names and highlighting across multiple excel sheets

[kdeppe]

Hi All,

I'm trying to develop a macro of some sort that will help me sort out a life of names. Here is a run-down of how I envision it working:

You would type a name into Column B of Sheet1. Sheet2 and Sheet3 already has a list of names typed in. If the name entered in Sheet1 matches a name is Sheet2 or Sheet3, then the name on Sheet2 or Sheet3 would be highlighted black.

Also, Column A of Sheet1 would have a list of names already typed in, so the name you type in Column B of Sheet1 would be "linked", for lack of a better word, to Column A. The hope is that the names in Column A of Sheet1 would be in Sheet4, so when a name is entered in Column B of Sheet1, that name would then be generated in Sheet4 adjacent to the name it was "linked" with in Column A of Sheet1.

Example: Sheet1 has "Ben" in cell A1. Sheet2 and Sheet3 have "Brown" in their respective A1 cells. And Sheet4 has "Ben" in cell E3, although this could be any cell. When you type "Brown" into cell B1 of Sheet1, then the A1 cells of Sheet2 and Sheet3 would be highlighted black, and "Brown" would appear in cell E4 of Sheet4.

Does anyone know how to VBA code this? Or have suggestions on any part of it?

Thanks!
Keegan

 

[Simon Lloyd]

Crossposted here http://www.excelforum.com/excel-pro...rent-sheets-and-highlighting.html#post2572950