chuf
Well-known Member
- Joined
- Jun 12, 2006
- Messages
- 619
I've read through old threads for the past hour or so and can't find an answer to this, appreciate any help please.
I have a pivot table which has a number of fields.
One field in the pivot table contains cc codes, four figure text with trailing spaces, and within the same spreadsheet, different worksheet, i have a list which gives me the cc code and the name of that code.
I'd like an additional column in the pivot table which uses a vlookup on the cc code and gives me the name.. i'd them like to be able to sort in the pivot table on the name and group them.
This must be possible, mustn't it ? ... but i'm stumped.
Any questions, or clarification please let me know.
I have a pivot table which has a number of fields.
One field in the pivot table contains cc codes, four figure text with trailing spaces, and within the same spreadsheet, different worksheet, i have a list which gives me the cc code and the name of that code.
I'd like an additional column in the pivot table which uses a vlookup on the cc code and gives me the name.. i'd them like to be able to sort in the pivot table on the name and group them.
This must be possible, mustn't it ? ... but i'm stumped.
Any questions, or clarification please let me know.