|
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
|