Hello,
I would like to ask if there is some code that will let me create, edit or delete comments for cells with formula that are changing base on selection in other cell.
To better describe what I mean I attach file. In sheet "Sample output v1" I selected in cell "D5" value X, and based on that formulas in cells below are changing. Now I want to add or change my comments below (like in cell E9 and E15). But than when I change selection in cell "D5" again, I want to see (add/edit and delete) comments valid to this selection. Outcome is showed in sheet "Sample output v2" where I have different comments in different cells.
Is there any way how to do this?
Thank you in advance for your help, comment and ideas.
Bookmarks