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

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