Create a comment from cells from another sheet

[Roger96_]

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. ):

 

[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.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.