Display Comments on Each Page
 

I have a spreadsheet that I need to add comments to. Currently the method to
leave comments about a particular cell is to use a textbox or shape with text
in it. As you can imagine this can clutter the spreadsheet.

I know you can have the comments print at the bottom of the sheet, however,
I need the comments to print at the bottom of the sheet that that cell is
printed on. So if I have a 3 page printout the comments on page 1 should show
at the bottom of page 1 not on page 4 all by themselves. I also need the
comments or would like to have the comments handle carriage returns. I know
how to pull out the comments for a range however I have run into the issue of
formating them. Anyone have any examples or ideas that can help me? Thank you.