Hi, I need to use a combo box value in a report filter for a series of pivot tables.
I have a combo box with a drop down list of suppliers on the dashboard front sheet and want to be able to select one of the values and then update all the pivot tables/charts with the report filter using that value selected.
Any ideas gratefully received!
Thanks
Richard
I have a combo box with a drop down list of suppliers on the dashboard front sheet and want to be able to select one of the values and then update all the pivot tables/charts with the report filter using that value selected.
Any ideas gratefully received!
Thanks
Richard