I require (hopefully very simple) consultancy advice on Excel 2007 VBA.
I have several pivots tables/pivot charts across multiple sheets, each displays slightly different data, but all connect to the same SQL ODBC view to get their data.
Instead of manually clicking each Report filter select the same value, I want a single drop down controlling all pivot tables/charts.
This was the web link I used:
I think I am almost there but I get VBA errors:
I have created a Dynamic Range and assigned it to a Combobox, which outputs row number selected to sheet 1, cell D4.
I use INDEX function in E4 to return the value of my selection.
I recorded a macro of me manually selecting the value for each pivot/chart.
I edited the macro replacing the selection with " Range("E4").text "
I assigned the Macro to the Combobox, the Macro errors:
"Run-time error 1004 - Application defined or object defined error"
I can demo this issue through remote desktop if this helps.
I need to understand the solution so can replicate on other reports.