| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Source data for pivot table to point to cell on worksheet?
I have several pivot tables on one page. They all have the same source
data. Is there a way to point the source data to a particular cell on a worksheet? Example: In the source data for the pivot table, point to cell A1 on Sheet1 to find out where to look. In sheet one will be the data range (i.e.) : Sheet1!$A$2:$F$18 This way, I can change the source for the entire sheet by changing what's in cell A1. Any clues? thanx! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code that will rerun or refresh a pivot table (after new data ispasted into the original Pivot Table's Source Range) | Excel Programming | |||
| pivot table multiple worksheet source data | Excel Discussion (Misc queries) | |||
| Pivot Table Source Worksheet and Range | Excel Discussion (Misc queries) | |||
| Pivot Table data source | Excel Worksheet Functions | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Linear Mode
