Hi all, new to the forum.

I have problem (which is probably simple for you guys)

I have a template which I will filter and import different customers products into and then it does a simple total at the bottom.
How do I get the table to automatically change size when the customers information changes.

Example:
Customer A has 20 line items (rows 1 to 20), row 21 being the total.

then I will filter for Customer B and they only have 10 line items (rows 1 to 10) with row 21 still being the total and rows 11 to 20 being blank (or reflecting 0 or N/A) and taking up space.

How would i get the table to automatically change size or adjust to be the best fit for the right amount of line items.

Basically i would like the Total row (row 21) to automatically move to row 11 in this example.
And would all the formatting like borders etc automatically change as well?


Thanks,
Rob.