Please note my goal is NOT "to update the comment every time a new value is entered that is not already present in the comment" only. It needs to chec...
Hi Hans, Thanks for your feedback. The file is attached here for your reference. Sheet1 encountered the problem I highlighted and the issue has been t...
I'm excited to revise the script as below. It works as expected. The key to skip updating the comment if it meets the condition is highlighted in Gree...
Thanks a lot for leading me to a new learning journey.
Hi Mynda, Sorry, I can't get your point. I really have no idea what I've done wrong. I surely respect and appreciate all the instructors' efforts h...
Hi Mynda, I just know it. Nothing can beat you! Be honest, I do get some solutions so far but yours is the best. The most amazing portion is tha...
It's my pleasure to report here I've fixed the automation error happened to me. The reason for that error is the sheet code name "Sheet3" was not in p...
Hi Anders, I tried to define a named range "pos" which refers to "F"&MATCH(TODAY(),Table[date],0)+1 then wrote the 3-D formula as SUM("Shee...
It seems a little tricky. The left side list is for code colors selection only not valid on font size. Although there are so many font types with limi...
Hi Catalin, My value of B16 comes from a data validation referring to a previous list I didn't update. Thanks for your highlight. Take the chance c...