Pivot Table data based on user input

M

Maver1ck666

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to Group in Pivot Table 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Pivot Table Question 2
Change Pivot Table Filter Based on Cell Value 0
Pivot Table Criteria Missing Data 4
Pivot table multiple filters 2
macro updating imported data and pivot tables 2
Using VBA to create charts 1

Top