My example didn't work out too well. Sorry.

Here is what it comes down. I have about 250 stores that I run pivots
on from time to time. When I take it out of the pivot format I don't
want to have to go back and drag or copy and paste all the missing data
for the stores column.

Thanks


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=491967