Forum Discussion

serious_sam13's avatar
serious_sam13
Copper Contributor
Feb 24, 2021

Reference Cell with notes

Is there a way to reference all data (including notes and/or comments) from a cell on one sheet to a cell on another sheet.  For example, on Sheet1, Cell A1 includes data and a note.  If I use someth...
excel
Joekelley78's avatar
Joekelley78
Copper Contributor
Jul 13, 2022

mathetes 

 

Here's an example of why one would want/need to see the notes for a cell on a cell reference.

 

I have my budget in Excel.  I have detailed notes (comments) attached to each transaction.  Each month has its own sheet.

 

I also have a summary sheet layed out differently, where I reference the 'total' cell of each column.  We just had a very hot, dry month so my water bill spiked.  In the Aug-08 sheet I commented about the reason for the spike.  But when I reference that cell (='Monthly Spend (08-22)'!J$6), it does not carry that comment with it to the summary sheet.  Therefore my son (who reviews my spending) cannot see the explanation as he reviews the summary sheet.

 

Make sense why including the comments on the referenced cell would be advantageous?

 

 

Jagodragon's avatar
Jagodragon
Iron Contributor
Jul 13, 2022
This gives you the complete comment from cell A1

ActiveSheet.Cells(1, 1).Comment.Text

Resources