Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Add Comments to Cells
Hi
Not sure if this is possible but.... I have a Worksheet where Columns C, E, G, I and K contain an Index and Match formula (referenced to another sheet where the raw data is stored) which returns either text where the Index and Match is True or "" where it is False Columns B, D, F, H and J contains a Row and Index formula (referenced to the sheet where the raw data is stored) which returns the Row number on the data sheet where the result in the corresponding cell in the next Column was derived or #N/A if the result was False. So, say the result in C4 was "Cream" and related to cell M681 on the data sheet the result in B4 would be 681 I hope this is clear so far. I now want to create a macro which will run down each cell in Columns C, E, G, I and K and if the contents = "" then do nothing otherwise add a comment the contents of which will be whatever is in the cell in Column R on my data sheet and the row number as set in the cell to the left. Using the example above, a comment would be added to cell C4 which would say "Ginger Baker, Jack Bruce, Eric Clapton" which is what is in cell R681 on my data sheet. I would really appreciate some help with this if possible. Many thanks Kewa |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Add Comments to Cells
hi
see this site.. http://www.contextures.com/xlcomments03.html regards FSt1 "nospaminlich" wrote: Hi Not sure if this is possible but.... I have a Worksheet where Columns C, E, G, I and K contain an Index and Match formula (referenced to another sheet where the raw data is stored) which returns either text where the Index and Match is True or "" where it is False Columns B, D, F, H and J contains a Row and Index formula (referenced to the sheet where the raw data is stored) which returns the Row number on the data sheet where the result in the corresponding cell in the next Column was derived or #N/A if the result was False. So, say the result in C4 was "Cream" and related to cell M681 on the data sheet the result in B4 would be 681 I hope this is clear so far. I now want to create a macro which will run down each cell in Columns C, E, G, I and K and if the contents = "" then do nothing otherwise add a comment the contents of which will be whatever is in the cell in Column R on my data sheet and the row number as set in the cell to the left. Using the example above, a comment would be added to cell C4 which would say "Ginger Baker, Jack Bruce, Eric Clapton" which is what is in cell R681 on my data sheet. I would really appreciate some help with this if possible. Many thanks Kewa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
Comments in cells | Excel Worksheet Functions | |||
merging cells and comments | Excel Programming | |||
Help with Macro for Zooming when cells have Comments? | Excel Programming | |||
VB Code to Add Comments to Cells from Several Other Cells | Excel Programming |