Hi
not tested but the procedure described at
http://www.contextures.com/xlPivot01.html
may also work for additional columns

--
Regards
Frank Kabel
Frankfurt, Germany

I posted something a little while back but I think it was too
complicated for a response. Not sure what the protocol on this is
(is
it still double posting if its clearer?). Thought I would instead
ask
a simple question?

Is it possible to update a pivot table's data fields using a dynamic
range? I know I can refresh it using a dynamic range with new data
and no change in range dimensions. But I don't know how to update
the data fields if the data AND the dimensions of the dynamic range
change.

Thanks


---
Message posted from http://www.ExcelForum.com/