Link to home
Start Free TrialLog in
Avatar of mcginniskj
mcginniskj

asked on

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
Avatar of SiddharthRout
SiddharthRout
Flag of India image

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
"without confusing the person who has to analyze the data"

What do you meant?
Avatar of mcginniskj
mcginniskj

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of jppinto
jppinto
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial