highlights name or puts number auto

[bohon79]

Hello,

is there a way in excel that if I use a name or something on one sheet into another sheet that it highlights/puts a number or auto fills data on the sheet. I have one sheet that has all are employees information on it. on another sheet is are positions in the company. if I put there name in the position then it highlight/puts a number or auto fills a set word in the sheet with the employee information.

thanks

 

[My Aswer Is This]

Excel can do all most anything. Give us a example.

Like if I put "George" in Range("A1") of sheet named "Master" then automatically put "Johnson" in range "B1" of sheet named "Parts"

Be specific about sheet names and column and rows.