I have found a VBA program that will take the comments in certain cells and display them onto a separate worksheet - noting the cell reference number, the cell value and the comment. However, I would like to reverse this capability. I would like to take a row indicating the cell reference, the cell value, and the comment, and when I run the program, it will insert the comment to the very cell referenced on that row. For instance:
Cell Reference Name Cube/Office
$C$5 John Doe South 112
Running the VBA program would then go to the cell referenced C5, insert "John Doe" as its value, and insert a comment "South 112".
Is this possible?