Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Pivot Tables
How do I set up a pivot table to automatically transfer the data from one
sheet into the table as it is input? |
#2
|
|||
|
|||
You can use a dynamic range as the pivot table source, and it will
automatically expand as data is added. There are instructions he 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. STEM726 wrote: How do I set up a pivot table to automatically transfer the data from one sheet into the table as it is input? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
How to change default page setup for pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Tables referring to external data query | Excel Discussion (Misc queries) | |||
How do I fix column widths in Excel Pivot Tables? | Excel Discussion (Misc queries) |