Is it possible to modify multiple rows based on a selection box?
Basically, I have a selection box that contains 3 selections, those selections are:
Selection 1: Jan, Apr, Jul, Oct
Selection 2: Feb, May, Aug, Nov
Selection 3: Mar, Jun, Sep, Dec
I would like to change a tables column to match my selection
On Table 3, I would like to the VAT months column to show the months based on what’s selected.
Is this possible?
I thought using ModifyRows would work looking at the formula guide but can’t seem to use it on a selection box.