....On one spreadsheet, I'm collating raw data each month about members of
staff who use our company eLearning portal: name, subject, time spent. I've
then created a Pivot Table on another sheet which fits the bill, except in
one respect. I've added a comment in the employee name cell if they pass the
course. When I refresh the Pivot Table monthly, it isn't in A-Z order (i.e.
new employees are added to the bottom). If I re-sort using the A-Z button,
any comments remain absolute instead of moving relatively with the employee
name. Any way round this or am I updating the Pivot Table incorrectly? FYI,
the only thing I do is to respecify the data range in the Pivot Table
wizard...

Thanks in advance
Amanda

Instead of adding the comments to the pivot table, you could add a
column to the source data, and add the Pass information there. Then, add
that field to the pivot table.

Birmangirl wrote:
...On one spreadsheet, I'm collating raw data each month about members of
staff who use our company eLearning portal: name, subject, time spent. I've
then created a Pivot Table on another sheet which fits the bill, except in
one respect. I've added a comment in the employee name cell if they pass the
course. When I refresh the Pivot Table monthly, it isn't in A-Z order (i.e.
new employees are added to the bottom). If I re-sort using the A-Z button,
any comments remain absolute instead of moving relatively with the employee
name. Any way round this or am I updating the Pivot Table incorrectly? FYI,
the only thing I do is to respecify the data range in the Pivot Table
wizard...

Thanks in advance
Amanda


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html