Create a dynamic comment based on values in another sheet

Hi,

I have been trying to find the answer for this for a few days and I am stumped. There are lots of solutions for turning cell values in to comments but none of them seem to match or work with what I need. Here is what I need to do:

In a workbook, Sheet2 Range B14:M14 contains values

I need to dynamically create comments with the contents of those cells and add them as comments to Sheet1 in Cells C14,E14,G14,I14,K14,M14,O14,Q14,S14,U14,W14,Y14

So to be absolutely clear:

Sheet2 B14 contents becomes a comment in cell C14 of Sheet1
Sheet2 C14 contents becomes a comment in cell E14 of Sheet1
Sheet2 D14 contents becomes a comment in cell G14 of Sheet1
Sheet2 E14 contents becomes a comment in cell I14 of Sheet1
Sheet2 F14 contents becomes a comment in cell K14 of Sheet1
Sheet2 G14 contents becomes a comment in cell M14 of Sheet1
Sheet2 H14 contents becomes a comment in cell O14 of Sheet1
Sheet2 I14 contents becomes a comment in cell Q14 of Sheet1
Sheet2 J14 contents becomes a comment in cell S14 of Sheet1
Sheet2 K14 contents becomes a comment in cell U14 of Sheet1
Sheet2 L14 contents becomes a comment in cell W14 of Sheet1
Sheet2 M14 contents becomes a comment in cell Y14 of Sheet1

The comments must update any time the values in Sheet2 change and the solution must work with Excel 2007.

Any advice would be gratefully appreciated!

K.

Thanks for the speedy response. I must be doing something wrong as this doesn't seem to be doing anything at all. Not sure if it should be placed in the code for sheet one or sheet two?

Originally Posted by humdingaling

Please Login or Register  to view this content.