Note or comment display in another cell

[Ettiene458]

Hi there.
Please assist...is there a way to create a note/comment for one cell and then display that note/comment as input text on another sheet?

For example:
Sheet 1
I have a table A1-10 to E1-10.
I enter data in A1 and add a note/comment for the same cell.

Sheet 2
I have the same size and range table on the second sheet.
I want the note/comment that I added for A1 on the previous sheet to display as text input in A1 on the second sheet.

Something like a link from note/comment to another cell.

 

[My Aswer Is This]

If you're talking about a Excel Table, it's always best to give the name of the sheet and the name of the Table on the sheet.

Like Sheets("Alpha").Listobjects("Table1").DataBodyRange

A script can run when a cell value is change is that what your wanting?
Not sure how to do that not knowing exactly what Range in the Table you are changing.