Hi, I need help. Currently i'm working on a macro in excel which will
automatically update the data in different worksheet.

1. I have a worksheet named "MTD" which carries all the information on
complain on the month. However there's a column where i named it
Notes, in this Notes columns, the individual cells has a long comment
to hold on to.

Problem
When i pivot the range of source of data in "MTD" worksheet to "Read"
worksheet, the length of the comments under Notes columns is being cut
off at a point. Which doesn't allow me to fully view the full msg.

Can anyone guide me thru and see if there's any codes or sample i
could use to do this macro.
Thank you! if any could help.