Hi everyone, I have an excel pivot-table whose source is an external SQ
server.
I have pulled across all the rows I want, however I want to create
new field that groups the "names" variable.

Is there a way to create a lookup or something in VBA that will grou
the names automatically everytime the data is refreshed?

Thanks for your help.

Scott

--
scottwilson
-----------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...fo&userid=1112
View this thread: http://www.excelforum.com/showthread.php?threadid=27152