Comment Reference

[Shay]

I have a workbook with multiple sheets (created by the previous user).
The 1<SUP>st</SUP> sheet (called Employee) has basic demographic data – name, address, hire date, etc
The 2<SUP>nd</SUP> sheet (called Phone) lists all the phone types and numbers
The 3<SUP>rd</SUP> (called Availability) lists the days and times preferred to work, etc
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Col A & B of each sheet show the office and EmployeeID but only sheet 1 shows the actual name (Cols D-F)
<o></o>
Is there a way on the Phone and Availability worksheets to dynamically have the name populate and “hover” as a comment in the ID cell without actually keying the name in the comment field manually? I do not want to add more columns to the worksheets.

Thanks!
<o></o>

 

[Shay]

Guess this can't be done? Thanks, anyway.

 

[ColinKJ]

Hi Shay,

I've only just read your original post.

I've put something together that you can take a look at if you want.

Send me a private message with an email address, and I'll send it over.

ColinKJ

 

[Shay]

Thanks so much. Your solution works beautifully.