Hello All,

I am new to Excel, but I fear I have a question that does not have an answer.

I am currently trying to set up a spreadsheet that will act as a non-conformance log sheet. One of my columns is designated to display the cause of the non-conformance using a 3 digit code but I would like to link each 3 digit code to another cell that will display a longer comment via hovering or clicking on the cell.

My G column is set to pull the cause code from the list I have selected from O1 - O23 via a drop down box (this part I already have set up). After a cause code is selected in G2 I would like to be able to mouse over or select G2 and have it display text that is specific to each cause code.

For example in cell G2 I hit my drop down box and select my cause code "Cu3" (which is linked to cell O14) I would like to be able to mouse over or click cell G2 and have it display "Customer - Damaged Threads".


I imagine I would probably need a macro for such a thing and I am hoping someone has already come up with such a thing.


If I need to describe my ultimate goal better let me know.

Thanks,
Ryan