Quote:
Originally Posted by rtour957
I expect cell value to be changing no more than 4 times so hopefully character limit won't be a problem. I agree that a separate log genrally makes makes much more sense but it also means that you'll have to go to a different tab where you'd keep it. With the total number of those rows and columns where I need date stamp it will be a nightmare to switch back and forth, whereas having date stamp and user in the comments will make it possible to dynamically check it without leaving the worksheet.
Thank you for looking into this,
Art
|
Hi Art,
Have modified, hopefully this is what you require. I have put in two checks one to determine if there is Data Validation, if there is then do something, in the do something part it then determines if there is any existing comment. If there is then add to the existing comments otherwise add comment.
Regards,
Gizzmo