Transferring Comments into a Pivot Table

So I have multiple tabs (see attached) and I'm hoping I can transfer my comment into my pivot table along with the data that is in the cell. I have a validation tab that has the cells with the comment. I want to transfer that cell and the comment into the data source tab (currently using a vlookup to pull the data, but clearly doesn't pull the comment as well), which will then go into a pivot table. If I have to take the comment and make that into a separate column (not ideal), I can do that, but I'd like to make it so that when you double click the name, it will show you all the details.

Currently, I don't really know how to do any of this, so if you could give me some help, that would be great. Thanks! See attached for the example.

View attachment Example.xlsx

Rose

Would you like a Pony with that as well? For somebody who does really know how to do any of this you are not asking much...!



A pivot Table will not read comments so do the following (I hate typing so it will be brief..)

Use this VBA code

Function Comment(incell) As String
On Error Resume Next
Comment = incell.Comment.Text
End Function

and insert it into you workbook as follows


https://www.screencast.com/t/WxkSD8mrA9T4



https://www.screencast.com/t/qhcV2lYv0qVU




https://www.screencast.com/t/XuruQ2DeQQyh


Will attach your file so that you can see what to do. Any problems let me know and if you feel this is slightly above your pay grade send me you actual file with 10 fictitious employees and I will do it. Then re-populate your table with the correct info.

Knock 'em dead Tiger!

Hopefully these come across as a thumbnail that you can open not as a full screen shot