I hope this is closer to what you want:
See encl. zip-file:
http://www.excelforum.com/attachment...tid=3507&stc=1
Ola Sandström
Note:
I've have included a Defined NameRange called DataTable. If you use
that instead of the Pivottable range (see the two pictures), Excel will
Dynamically expand the Pivottable range = the Pivottable range will
always be the length.
+-------------------------------------------------------------------+
|Filename: Book4.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3507 |
+-------------------------------------------------------------------+
--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread:
http://www.excelforum.com/showthread...hreadid=379185