I don't think you can tie those adjacent cells to something in the pivottable.
There are just so many things you can do that I would think it would be
impossible to do it automatically.

If you can pick out a unique value, maybe you could put the notes in another
worksheet and use =vlookup() to retrieve that "comment" into the adjacent cell.
(But that, too, would depend on what you did to that pivottable.)

robertjtucker wrote:

I like the way inserting the comments works, putting the name in and
everything but if there is comments in cells right above or below they
overlap and you can't read them if you alow them to be viewed all the
time. Like you said if it is in adjacent cells out of the pivot then
the text gets jumbled if you sort or use the drop boxes. Can you group
them with a part of the pivot table so the cells that are not in the
pivot will move with the data in the pivot.
Thanks for you input Dave,
Bob

--
robertjtucker
------------------------------------------------------------------------
robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805
View this thread: http://www.excelforum.com/showthread...hreadid=391067

--

Dave Peterson