I am trying to combine the text from the comments boxes of a full row of cells into the comments box of a seperate other cell in order to provide an overview of the comments in these cells in one place. I cannot for the life of my think how to do this.

Any help would be appreciated..

Thanks