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? |
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 |
All times are GMT +1. The time now is 02:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com