| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Pivot Table source
Hello all,
I haven't tried this yet, but I was wondering, when creating a pivot table based on data in the current workbook, if the source range can be dynamic using the OFFSET() and COUNT(A)() functions. Thanks for any help anyone can provide, Conan Kelly |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
| entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
| updating pivot tables using dynamic data source | Excel Discussion (Misc queries) | |||
| Transforming pivot table back to the source table | Excel Worksheet Functions | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Threaded Mode
