Add comments based on two criteria

Status
Not open for further replies.

Roger96_

New Member
Joined
Jun 28, 2021
Messages
5
Platform
  1. Windows
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!
 

Attachments

  • A6758F32-B455-43B6-93F6-938903A0E343.jpeg
    A6758F32-B455-43B6-93F6-938903A0E343.jpeg
    215.9 KB · Views: 7
  • 1C187F2F-745D-42D9-B238-FFBA67F53DE6.jpeg
    1C187F2F-745D-42D9-B238-FFBA67F53DE6.jpeg
    193.5 KB · Views: 9

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

EFANYoutube

Active Member
Joined
May 19, 2017
Messages
278
Are you wanting to replace the color strings with the pertner strings?
Oh hold on, like a cell comment?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
37,334
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
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.
 
Status
Not open for further replies.

Forum statistics

Threads
1,141,121
Messages
5,704,427
Members
421,347
Latest member
vrajesh544

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top