| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table data based on user input
Genius! Cheers for the link.
"Roger Govier" wrote: Hi Debra Dalgleish has a sample workbook which shows how to do this, by adding one extra column to your source data http://www.contextures.com/PivotDateRange.zip -- Regards Roger Govier "Maver1ck666" wrote in message ... I have a basic pivot with "Category" as the column, "Request_Date" as the row and a count of "Category" as the results. At the moment, I have over 2 years worth of dates going down column A which I would like to be able to filter. What I would like to do is have 2 cells, say "B2" & "B3" where a user can type a from and to date. This will then automatically refresh the data in the pivot table which in turns, refreshes some other charts running off the table. Is this possible? Please say yes :) Oh, Im new to Pivot Charts (not excel) so if you could simplify your explanations, that would be most grateful. Kind regards, Maver1ck666 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting Data from another worksheet based on user input | Excel Worksheet Functions | |||
| Run query to get data from Access based on user input | Excel Programming | |||
| Incrementing Data based on user input | Excel Discussion (Misc queries) | |||
| Copy cell data from workbook based on user input | Excel Programming | |||
| select data based on user input | Excel Programming | |||
Threaded Mode
