I searched many forums but did not get any expected results. Below I am sharing my thoughts, hope someone could help me in this context.
In my worksheet (Worksheet Name Bill), I want Cell "I" will show the value of "W, X & Y"
My Comments range is I9:I1200
My data range is "W, X & Y" from 9 to 1200
In comments the comment will show as " Product ID: "W" value, Product Amount: X value & Product Paid Amount: "Y" Value.
If No data in "W, X & Y" then no comment.
If data changes then the comment updates automatically but no need of old values to show in a comment.
(If the code run in the module will be best for me)
Hope I am able to describe it. Help on this would be much appreciated.
Thanks in advance