how to insert comments in excel 2010 pivot table

How can I insert comments into cells in a pivot table without confusing the person who has to analyze the data? Thanks in advance

KM
mcginniskjAsked:
Who is Participating?
 
SiddharthRoutCommented:
This is a basic code to add comments to cell A1 in Sheet1. Please amend it for realistic situations.

On Error Resume Next
Sheets("Sheet1").Range("A1").Comment.Delete
On Error GoTo 0
Sheets("Sheet1").AddComment Text:="Blah Blah"

Open in new window


Sid
0
 
jppintoCommented:
"without confusing the person who has to analyze the data"

What do you meant?
0
 
mcginniskjAuthor Commented:
The attached spreadsheet is an inventory snapshot  that has been classified as Surplus, Excess, and Overstock.  

1) I need to review the items on hand (across all locations) and identify the following:
a. What items can be sold, scrapped, or kept as critical spares  

I need to know the best way to enter my comments.

Thanks
01.15.11-OES.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.