Hi all, I hope someone can help... for this particular puzzle I prefer NOT to use Slicers or VBA codes (not sure if this is possible without VBA)
I have setup a hidden Pivot Table which I would like to be able to control based on a cell value on another visible sheet.
E.g., if I type in "Fruits" in cell A1 in the visible sheet, I would like the hidden Pivot Table to filter on items under category "Fruits".
My intention is to later link a check box or a list box (form controls) to the cell (or cells) to automate. Thanks in advance!
I have setup a hidden Pivot Table which I would like to be able to control based on a cell value on another visible sheet.
E.g., if I type in "Fruits" in cell A1 in the visible sheet, I would like the hidden Pivot Table to filter on items under category "Fruits".
My intention is to later link a check box or a list box (form controls) to the cell (or cells) to automate. Thanks in advance!