Hello There,
I have two worksheets having Table1 and Table2.
Note: Table2 is the formula reference of Table1.
Sheet1: Table1 has 3 columns and has 10 rows. 3 rows are filled and 7 rows are empty
Sheet2: Table2 has 3 columns and has 10 rows. 3 rows are filled and 7 rows are empty
What I do is the following:
1. I copy 100 rows data from another worksheet and paste it in worksheet Table1.
2. In worksheet Table2, after grouping the data from Table1 I expect 80 rows in Table2.
However, the worksheet Table2 does not get extended to 80 rows, it just stays at 10 rows. I have to manually extend the Table2.
Requirement: Based on the number of data that can fit, Table2 should expand and contract automatically. How can this be done?
Appreciate your help.
Many thanks
Don
I have two worksheets having Table1 and Table2.
Note: Table2 is the formula reference of Table1.
Sheet1: Table1 has 3 columns and has 10 rows. 3 rows are filled and 7 rows are empty
Sheet2: Table2 has 3 columns and has 10 rows. 3 rows are filled and 7 rows are empty
What I do is the following:
1. I copy 100 rows data from another worksheet and paste it in worksheet Table1.
2. In worksheet Table2, after grouping the data from Table1 I expect 80 rows in Table2.
However, the worksheet Table2 does not get extended to 80 rows, it just stays at 10 rows. I have to manually extend the Table2.
Requirement: Based on the number of data that can fit, Table2 should expand and contract automatically. How can this be done?
Appreciate your help.
Many thanks
Don