Hi Excel geniuses!
Is there a way to have the result of a calculation automatically appear in a comment box related to a specific cell. Or by using a message box?
I have a few columns (B through H) of financial info on a single worksheet that are part of a monthly financial presentation to upper management. Although it might be a little useless, I thought it might be kind of neat to have a calculation (((actual costs / # of months in fiscal year)* 12) - forecast) where another column (or scrolling) would not be needed. Is this possible?
Thanks in advance!
Steve
Is there a way to have the result of a calculation automatically appear in a comment box related to a specific cell. Or by using a message box?
I have a few columns (B through H) of financial info on a single worksheet that are part of a monthly financial presentation to upper management. Although it might be a little useless, I thought it might be kind of neat to have a calculation (((actual costs / # of months in fiscal year)* 12) - forecast) where another column (or scrolling) would not be needed. Is this possible?
Thanks in advance!
Steve