I have created an excel template where i want the values to be displayed in a simple table, see below:
the table covers cell A1-F3 (excludes Total)
however, when the report is generated, the table only stops at the second cell which makes sense since that is what the template has.
Is there a way to get the table to expand to take in all the values that are to be generated?