| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating pivot tables using dynamic data source
You need a heading in each cell in the first row of the pivot table
source range. If there is data in column A, above the source data, you can subtract it in the offset formula: =OFFSET(Data!$A$10,0,0,COUNTA(Data!$A:$A)-COUNTA(Data!$A$1:$A$9),64) dab4211 wrote: Thank you. I am still confused. My source data begins in cell A10 because I placed titles above row 10. I have entries ("headers") in every cell in row 10 identifying the data in each column. I think I will try it without the titles. Should I begin without anything in the spreadsheet except column headers? Again, thanks so much! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table data not matching source | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
| updating pivot tables | Excel Discussion (Misc queries) | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Threaded Mode
