Add comments based on two criteria

[Roger96_]

Hi, am new to this forum
I managed to find some threads similar to this, but doesn't really meet my expectation
I looking for a VBA code, where a comment has to be added based on the cell value.
It’s important to mention that the comment is extracted from another sheet.
That is, for example in the sheet Date there are different colors with different partners. Is it possible to have a code that compare if there is a cell on the other sheet with those parameters and return a comment with that information? For example in “Date” C6 it is white and the partner is Chevrolet, then in the other sheet (“Model”) this Information is placed in cell D6 with the model Trax. I’d like a comment in C6 in Date that says “Trax”

Is it possible to have a code that adds comments based on two criteria?



can someone be able to help me out ?

thank you so much in advance!

 

[EFANYoutube]

Are you wanting to replace the color strings with the pertner strings?
Oh hold on, like a cell comment?

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Add comments based on two criteria - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Fluff]

Duplicate to: Create a comment from another sheet

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

Please stop making duplicated posts.