Dynamically resize the table

Question

Hello,

I want to know how can i resize my table dynamically?

as My table depends on the other sheets.

I am explaining you through an example:

There is a sheet named as "Source" which is actually a pivot table created from power BI report. After refreshing the sheet, the number of rows may get change.

and I am using this data in another table which contains a lot of formula.

so after refreshing the size of source gets changed but size of my table remains unchanged. so I want that the size of my table should also change dynamically.

***Post moved by the moderator to the appropriate forum category.***

Answer 1

Hi Ramon,

Well, I have found an alternate solution,

As my source table is pivot table, so I need to use COUNTA() to find the number of rows.

And I am working with macros also, so I used listObjects() and resize().

So now as number of records gets changed in source, the size of table gets automatically set.

This is helping me out because column numbers are fixed.

I need a formula also, if you could help me out.

Thanks

Answer 2

Hi, I am using Excel16.

I know I have a drag option to resize the table, but I want to know the formula, which will automatically run, as the source size gets changed.

Thanks

Answer 3

Hi Manisha,

We would like to know which version of Microsoft Excel you are using?

We suggest that you check the articles below for your concern regarding Excel tables.

Overview of Excel tables.

Using structured references with Excel tables.

Let us know how it goes.