D
dave
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
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