Hi
I've created a pivot table in the background of a report, that uses 6 report filters.
As the amount of data coming back from exceeds what needs to be dispalyed on the front sheet, I've created a series of listboxes that read infomation from the datasheet.
Is there a way of linking the listbox with the corresponding report filter in the pivot table, either through VBA or any other method that any knows, so that when the user picks from the drop down list on the listbox it changes the pivot table in the background.
I've been able to match all my data displayed in the piviot table onto the front sheet already, so it's just allowing for the change on the report filter.
Is this possible?
Thanks
I've created a pivot table in the background of a report, that uses 6 report filters.
As the amount of data coming back from exceeds what needs to be dispalyed on the front sheet, I've created a series of listboxes that read infomation from the datasheet.
Is there a way of linking the listbox with the corresponding report filter in the pivot table, either through VBA or any other method that any knows, so that when the user picks from the drop down list on the listbox it changes the pivot table in the background.
I've been able to match all my data displayed in the piviot table onto the front sheet already, so it's just allowing for the change on the report filter.
Is this possible?
Thanks
