Just beginning to dabble in VBA and having issues with finding a workaround to an error, similar to Excel's "IfError" statement.
I have several pivot tables sync'd with VBA coding (http://www.datapigtechnologies.com/flashfiles/pivot10.html), but I'm having issues syncing additional pivot tables from another data source. I'm assuming that VBA is bugging due to the filters not having exact matches between the data sources (ie. data source 1 has 10 locations, data source 2 only has 5 of those 10).
I've looked into coding and have found there is a fix that diverts the values to an "All" sum (and I'm assuming this is possible since the pivot tables have the value "(All)" in the filter); however, this is not a viable fix as some of these filters should show no values at all.
The pivot tables are linked to a dashboard that has a form control which changes the filters on all the synced pivots. Is there coding that I can add to the VBA that will say something to the effect that if location 6 is not in this pivot, show 0? Like an IfError statement.
Thanks so much for any assistance!
I have several pivot tables sync'd with VBA coding (http://www.datapigtechnologies.com/flashfiles/pivot10.html), but I'm having issues syncing additional pivot tables from another data source. I'm assuming that VBA is bugging due to the filters not having exact matches between the data sources (ie. data source 1 has 10 locations, data source 2 only has 5 of those 10).
I've looked into coding and have found there is a fix that diverts the values to an "All" sum (and I'm assuming this is possible since the pivot tables have the value "(All)" in the filter); however, this is not a viable fix as some of these filters should show no values at all.
The pivot tables are linked to a dashboard that has a form control which changes the filters on all the synced pivots. Is there coding that I can add to the VBA that will say something to the effect that if location 6 is not in this pivot, show 0? Like an IfError statement.
Thanks so much for any assistance!