Add comments based on cell value

  • 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:]

    [Blocked Image:]

    Thank you so much in advance and stay healthy!