Code for hover data

[Cantonalives]

Hi,
Is there a way to amend the data that pulls through when you hover over a cell? I am guessing that comments to every cell is the best approach?

Essentially I have a pivot and would like to have information that is derived from an index/match formula with the data stored on another sheet.

I am making an assumption that this can only be achieved via VB?

Any help much appreciated.

Thanks,


-CL

 

[Chihiro]

Your assumption is correct. It would require vba.

See link below for very good tutorial on manipulating comments through VBA.
http://www.contextures.com/xlcomments03.html

If you need help with coding, I'd suggest you upload sample file with enough data. And sample of what info should be placed in comments.