| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Data From a Pivot Table to autofill
In Excel 2002 and later versions, a GETPIVOTDATA formula is
automatically created when you link to a cell in a pivot table. There are instructions here for adding the Generate GetPivotData button to a toolbar, and toggling that feature on and off: http://www.contextures.com/xlPivot06.html When it's turned off, you'll create a normal reference when you click on a cell in the pivot table. Then you'll be able to copy across or down. barbb wrote: How do I use data from a pivot table in a formula outside of the pivot table, and autofill down? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
| How to set the autofill options in a column of a input data table | Excel Discussion (Misc queries) | |||
| Is there an autofill for all row fields in a pivot table? | Excel Worksheet Functions | |||
Hybrid Mode
