Maybe i'm not using the right terms and that's why i'm not finding what I am after, but I am trying to generate a table/chart/form that only includes data from the options that are selected (radio buttons and check boxes).
As it sits, I have a chart that populates the cells with data as the units are selected, but otherwise leaves the cells with 0.0 when the unit is not selected. Here is that chart and the selectable options. I would like the chart to be generated to include data only from those selected units. The purpose of generating this chart is for it to be copied to an email going to customers.
Is there an option in Excel that I can utilize for this? Do I need to learn VBA and implement that somehow?
Aucun commentaire:
Enregistrer un commentaire