cell information
 

curious - is there a way to program excel (or is there an available feature)
where i can rest my cursor over a cell and it will tell me what that value
is derived from?

ex -
I have Sheet1 linked to Sheet2.

On Sheet1, cell R748 is linked to cell D37 on Sheet2.

D37 on Sheet2 is "Joe's Average Price".

What i want to be able to do is select cell R748 on Sheet1 and have a popup
tell me it's "Joe's Average Price" rather than 'Pricing Sheet'!D37

is there a way to program comments that will update automatically? or
should i create named ranges? i am not sure how to approach this.

thanks for your help