Pivot Table Manual Input via linked cell.

[suttonutd]

Hi,

I am currently working on updating our spreadsheets to be a bit more dynamic, and I came up with a small issue that I dont know how to fix.

On Pivot tables you can have the report filter which filters the data so you only see what you want. The issue I have is that I want the user to not have to select these filters, but instead have a manual entry tab where they put in their selection and the pivot table works in the background via linked cells.

Is there a way to get it so the filters can be changed via a linked cell? Or is there an alternative way?

Thanks,

Steve.

An example for anyone a bit confused.

Manual Entry tab:
Cell a1: "Please type in the animal you want to find"
Cell a2: Users choice (for this example 'Dog')

Pivot table tab:
Cell b2: This is where the filter choice sits. This will hopefully be linked to manual entry a2 so when the user types in a value this changes to show the data for that choice. (so for this example it will show only the data for 'dog')

 

[danzon]

Have a look at about the 8th entry from Sachin... this should get you what you are after.

Apply filter to all pivot tables in a sheet via macro. « Chandoo.org - Learn Excel & Charting Online - Forums

If you are using Excel 2010 you can also use slicers to achieve the same