Can I populate notes/comments by drawing data from other cells?
Can I populate notes/comments by drawing data from other cells?
Comments do not accept functions. Therefore it isn't possible to draw data into them without outside help. However, it's possible to use VBA to transfer data from a worksheet cell to a comment.