that’s the tables I’m working with, I hope it’s more understandable!
MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
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!
Hi Roy, thank you so much for your answer and advice, that’s the workbook I’m working with!
Good afternoon to all,
I’m trying to put comments on cells that correspond to information from another sheet in the same book. (I attach images to make it more understandable.) On the “Data” sheet I have different features and percentages and on the “Info” sheet I have a table with the corresponding information for features and percentages. I would like to create comments on the “Data” sheet with the Information on the other sheet. Is IT possible to create a code where the data looks for the corresponding information on another sheet? For example: in the Data sheet the cell C3 corresponds to networking and 0%. Is it possible that it looks in the Info table of B1:G1 for the corresponding percentage and in A2:A8 for the corresponding feature? In this case it would be B3 and you will create a comment with this information?
I have excel version 2008, I’m not very used to work with VBA that’s why I’m struggling with it.
Thank you so much in advance and I hope you all have a great day and start of the week!
As additional information, I had previously created a code with fixed cells and everything worked fine but the Data and Info table will get bigger and sometimes rows and columns will be added in the middle of the table, so the rows and/or columns will expand and the information no longer corresponds to the code.
[Blocked Image: https://www.mrexcel.com/board/attachments/1624953263558-png.41801/]
[Blocked Image: https://www.mrexcel.com/board/attachments/1624953298059-png.41802/]
Thank you so much in advance and stay healthy!