p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Excel VBA (http://p2p.wrox.com/forumdisplay.php?f=79)
-   -   Pivot Table Dynamic Reference Data (http://p2p.wrox.com/showthread.php?t=33236)

oyelesit September 8th, 2005 03:15 PM

Pivot Table Dynamic Reference Data
 
I already have a pivot table created using pivot table wizard. The layout for the pivot table is expected to remain unchanged. However, I am trying to write code that adjusts the reference source range to reflect the number of rows in the source range (located in a different worksheet). In other words, the only thing that is expected to change regarding pivot table and/or source data is number of rows. Can you assist? Thanks.

(By the way, I have seen several codes using the PivotCaches.Add method. However, I think it's an overkill for my purpose)

T Oyelesi

mjppaba September 9th, 2005 02:35 AM

may I suggest you look at the following posting...

http://p2p.wrox.com/topic.asp?TOPIC_ID=34586

It follows a very similar line to your requirement.

Cheers

Matt


ladybird August 4th, 2006 07:28 AM

comanalysis@yahoo.co.uk

Hi Tobi,

This is way off the subject but do you know a Janet Adeyemi??
:)

Quote:

quote:Originally posted by oyelesit
 I already have a pivot table created using pivot table wizard. The layout for the pivot table is expected to remain unchanged. However, I am trying to write code that adjusts the reference source range to reflect the number of rows in the source range (located in a different worksheet). In other words, the only thing that is expected to change regarding pivot table and/or source data is number of rows. Can you assist? Thanks.

(By the way, I have seen several codes using the PivotCaches.Add method. However, I think it's an overkill for my purpose)

T Oyelesi


All times are GMT -4. The time now is 05:04 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.