Pivot Tables

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

Guest

How do I set up a pivot table to automatically transfer the data from one
sheet into the table as it is input?
 
You can use a dynamic range as the pivot table source, and it will
automatically expand as data is added. There are instructions here:

http://www.contextures.com/xlNames01.html

To refresh the pivot table automatically, you could record a macro as
you refresh it manually. Then add that code to an event procedure, such
as activating the pivot sheet.
 
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

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pre-configuring Pivot table "views" 4
Workbook pivot table design function 6
Average of Subtotals in Pivot Table 0
Pivot Tables by Macro 2
grouping dates in a pivot table 1
Pivot Table using data from multiple sheets 1
Pivot Table Comparison 1

Back
Top