Hi All,
I've been playing a lot lately with the pivot tables. I'm building a dashboard atm using a combination of datasets, supported by VBA.
What I would like to accomplish is already quite clear but I have not been able to build it myself as my VBA skills only go so far.
I intend the following (and i included a dummy workbook to illustrate the context)
What I would like to be able to do is to type a component into "dashboard F3".
This returns to me a list of product IDs from "compositions column A:A", that match the component of interest.
This list of IDs is then stored as a named range
The named range is then plotted into the product filter of the pivot table.
Consequently, the pivot table returns to me the number of sold products over time that use the component of interest in its composition.
(shortcuts or alternative solutions are welcome as well )
Best
Bookmarks