Can I... (trying to be clever with pivot tables)

tazeo

New Member

Join Date: Feb 2007

Location: Queensland, Australia

Posts: 5

15th Feb 2007

Hi All
I think this is possible, but I can't find a definite Sample of code to do so.

I want to have a pivot table to auto generate (which I can do) but I want it to dynamically change the between dates, which would be referenced elsewhere in the workbook. Basically I need to automatically create a table that is for the last 3 months, one for the last 12 months, and one for financial year (jul-Jun).

Am I delusional, or can it be done.

Last edited by tazeo; 15th Feb 2007 at 05:39 AM.. Reason: spelling sucked

« Sum | Using the Return Key without exiting Textbox »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot tables - Editing the data source shared by multiple pivot ta	sankat	Microsoft Excel Misc	1	22nd Apr 2010 03:05 PM
Building pivot tables in Excel 2007 based on existing pivot tables?	jj.jigga.johns@gmail.com	Microsoft Excel Misc	4	26th Dec 2007 08:05 PM
(Tom?) Pivot tables, code to refer to all pivot tables on template	=?Utf-8?B?a2x5c2VsbA==?=	Microsoft Excel Programming	0	20th Jul 2007 09:32 PM
How does the term 'pivot' apply to Excel's Pivot tables and Pivot.	=?Utf-8?B?c3R2ZXJtb250?=	Microsoft Excel Misc	1	17th Feb 2005 01:34 AM
Pivot tables-controlling user interaction with pivot tables	Sindhura	Microsoft Excel Programming	0	27th Aug 2003 02:10 PM