Inserting Note Based on Cell Value

[Luxurae]

Hi All,

I'm trying (and failing) at getting excel to automatically insert a Note based on a specific cell value.

i have my conditional formatting set up so that when a WBS code is inserted it changes to a specific pattern/colour, that is working fine.

what i want it to do is to insert a note based on that cell value to show a name when you hover over the cell.

so for example;

Cell Value = "PF1" - insert note "First Name, Last Name" into that cell

Cell Value = "CH1" - Insert note " first Name, Last Name" and so on...

I have a hidden sheet with my name data, im just unsure if this would be a formula, a macro or conditional formatting?

hope that makes sense,

TIA

i've tried conditional formatting based on a formula but to no avail and im not clued up enough to write a macro by hand!

 

[davesexcel]

Where are the first and last names located? Where would PF1 or CH1 be located?

 

[Luxurae]

Where are the first and last names located?

Hi Dave,

I have setup a sheet in the same workbook to show the names and WBS code

 

[davesexcel]

I was referring to columns or rows that the data is located. Can't add first or last names without knowing where they are.

 

[Luxurae]

My apologies...Long Day!

First Name; A3-A42
Last Name; B3-B42

located in a sheet named "Labour Pool"

 

[davesexcel]

Where is:
Cell Value = "PF1" - insert note "First Name, Last Name" into that cell
Cell Value = "CH1" - Insert note " first Name, Last Name" and so on...

 

[ReneeDJ73]

Where is:
Cell Value = "PF1" - insert note "First Name, Last Name" into that cell
Cell Value = "CH1" - Insert note " first Name, Last Name" and so on...

Hello,
Can you please elaborate? I would like to do the same, yet I can not use VBA on my shared worksheet. If you could elaborate on your answer, I would appreciate it greatly. I need a comment or note to show up if Column A contains any of three specific names. I would like the note to show up in Column I of my worksheet.