Hello!
I am brand new to vba coding. I am part of a small project team creating a dashboard. I created a couple of user forms. Long story short, this is the last portion. Here is the scenario. This is a macro-enabled workbook for the Board of Education. The workbook is 31MB and located at https://maraviglia.box.com/s/62fzutikagjq7e20l4dj. Click on View on the top and then look to the right on the ribbon if you can. Click on the Parameter Selection icon. see screenshot
This allows the user to select the entity to examine. If they do not select an ISD in combobox1, it should default to everything. If they select an ISD like Oakland Schools above, but nothing in Combobox2 than all School Districts will be included and so on. Once they have made their selection, they click OK. Now, what hopefully should happen is the data for their selection should be pulled from the “Combined” tab and put in the Pivot Tables on the Working Pivot Tables tab. Once that is done, another function should take the data from these Pivot tables and “refresh” the graphs and charts on the Summary tab at the front of the workbook.
There is no code yet as I have no idea how to approach this. It's not a simple "RefreshAll".
One thing I’m still trying to correct is the data that populates this workbook comes from a web site that must be downloaded manually (don’t ask). It comes down as csv. You can see from the image above the “code” columns should be 5 characters with leading zeroes. Unfortunately, the source data is not that way. I have saved the source file as xlsm, formatted these code columns as custom since text won’t work and imported them into the workbook. The data moved over to the Pivot Tables (manually done to this point) does not maintain the leading zeroes.
I am brand new to vba coding. I am part of a small project team creating a dashboard. I created a couple of user forms. Long story short, this is the last portion. Here is the scenario. This is a macro-enabled workbook for the Board of Education. The workbook is 31MB and located at https://maraviglia.box.com/s/62fzutikagjq7e20l4dj. Click on View on the top and then look to the right on the ribbon if you can. Click on the Parameter Selection icon. see screenshot
This allows the user to select the entity to examine. If they do not select an ISD in combobox1, it should default to everything. If they select an ISD like Oakland Schools above, but nothing in Combobox2 than all School Districts will be included and so on. Once they have made their selection, they click OK. Now, what hopefully should happen is the data for their selection should be pulled from the “Combined” tab and put in the Pivot Tables on the Working Pivot Tables tab. Once that is done, another function should take the data from these Pivot tables and “refresh” the graphs and charts on the Summary tab at the front of the workbook.
There is no code yet as I have no idea how to approach this. It's not a simple "RefreshAll".
One thing I’m still trying to correct is the data that populates this workbook comes from a web site that must be downloaded manually (don’t ask). It comes down as csv. You can see from the image above the “code” columns should be 5 characters with leading zeroes. Unfortunately, the source data is not that way. I have saved the source file as xlsm, formatted these code columns as custom since text won’t work and imported them into the workbook. The data moved over to the Pivot Tables (manually done to this point) does not maintain the leading zeroes.
