Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dynamic Datasource Code for Pivot Tables
Can someone please help me out. I am trying to build a pivot table that will auto update and within the table do groupings by week. My source data headings are on Row 1 and data covers columns A-H. One of the sticking points I have is that their are some blanks in columns C,R,G,H. Can anyone tell me how to get this to work?
|
#2
|
|||
|
|||
Quote:
this can achieved by using named range for pivot source. insert a named range called "PIVOTDATASOURCE" =OFFSET(INDIRECT("Sheet1!$A$1"),0,0,MAX(COUNTA(IND IRECT("Sheet1!$A:$A")),2),COUNTA(INDIRECT("Sheet1! $1:$1"))) replace sheet1 with required sheet name as per your requirement in the formula. now instead of selecting the data source manually, give PIVOTDATASOURCE all the best
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables and dynamic columns | Charts and Charting in Excel | |||
Datasource for pivot tables | Excel Discussion (Misc queries) | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
Dynamic Pivot tables | Excel Discussion (Misc queries) |