| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using dynamic range to create pivot table
Check your other thread.
Michael wrote: Hi, I wonder if you could help me with the problem you had. How did you incorporate the dynamic range into the macro for your pivottable please? My data comes from a file that is downloaded from another program so I would have to name the range in the macro. Is this possible, and if so would you be able to tell me how please? Thanks in advance. "cursednomore" wrote: I have data that is downloaded on a weekly basis, and am trying to create a macro to create a pivot table for an end user who is not very Excel fluent. Because the size of the data will change each week, I used the information at Debra Dalgleish's web site: http://www.contextures.com/xlPivot01.html However, when I try to run the Pivot Table wizard, and select the named range as the range to get the data from, it tells me "reference is not valid". I feel that I must be missing something, but have no clue as to what it is. Can someone please help? Thanks in advance!! -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
| How do I create multiple pivot charts from one pivot table? | Charts and Charting in Excel | |||
| Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
| How do I create a pivot table from multiple pages of data? | Excel Worksheet Functions | |||
| Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
Threaded Mode
