Report Filter vs Userform ?

[ccline]

Hello,

I'm new to the forum and am looking for some assistance.

Here is my scenario, I have a report that has a data dump in one tab (say its product information by vendor. I would like to have 3 views (or tabs) of the source data (data tab) for 3 different audiences:

1. View one: Operations View
Rows @ top would have qunantity & value by each plant
Columns would have SKUs/Material IDs
There would be the ability to have a Product list box that 'filters' out all the other products/sku's by the product selected.

2. Product Reporting
Report have 2 filters (Product & Sub Product - dependent values based on Product chosen). Data output based on what's selected in the filters/parameters

3. Inventory View
Report should have two filtering/parameters: By Vendor, then by Product (Product is dependent on Vendor)

Any guidance/help is appreciated!

CC

 

[rallcorn]

Welcome!

Try using PivotTables. They would pull from the one data source.

 

[ccline]

Thanks for the idea - Pivots in this instance I don't think will assist. We have a pre-built template that the user wants to toggle on/between.

Is there any ability to alter the pre-defined template to dynamically filter the results without using pivot functionality?