This looks like an excellent idea.

Thanks steve1001.

"steven1001" wrote:


You could try maintaining a list of what people actually enter and put
what you want it to be in the next column. eg

Col A Col B
Comp Computer
PC Computer
Computer Computer ... etc

Then you could do a vlookup against Col A based on what the user had
entered and populate another column in your data with the looked up
value from Col B, then use that value in the pivot table.

regards....


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=557330