Hi does anyone know a simple VBA code for a text input box on the excel page to filter a pivot table by for example Itemcode.
I know you can use a standard filter but this removes the Itemcode out of the row, also a slicer wont work because there are to many values
Thanks
I know you can use a standard filter but this removes the Itemcode out of the row, also a slicer wont work because there are to many values
Thanks