Change the range of a pivot table data source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
Hope someone can help with this. I want to load a raw data file each month
into a template workbook. The size of the raw data changes so I want to
change the source range for each pivot table.

How do I determine where the raw data ends (rows and columns) and tell the
pivottable data source to use the new reference?

Any help you can provide would be fantastic.
 
Ok. My gameplan is to first import the csv file, then using vba name the
range of data using the OFFSET function( is there documentation on this and
the SUBTOTALS functions?), next using vba change the source of the pivot
table.

Thanks for your help. I have been to your site before. It is great!
 
Thanks for letting me know that you like my site!

There's information on OFFSET and SUBTOTAL in Excel's Help, and you can
download Peter Nonely's function workbook from Ron de Bruin's site:

http://www.rondebruin.nl/id.htm
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Used Range and Source data of a Pivot Table 1
Please help! Cannot open pivotTable source file.... 2
Change Pivot Table Range 2
DYNAMIC RANGE FOR PIVOT TABLE 1
Macro to update pivot table data range 3
Pivot Table - Source Data Information 2
How do I change source data range for an existing Pivot Table? 1
How to maintain dynamic data range for Excel PivotTable 4

Back
Top