I'm sure this is something easy but I just can't work out how to do it and its puzzled me for a long time.
I have a master table this is created from an export into an excel workbook. This is from a database and has a large number of columns and rows.
From this master table I have a number of other tables which reference the master table. So sub table 1 would ref cell A2, B2, C2 (using the = formula) to create a new table. I can then drag this down to ensure it covers all the rows in the master table. So say that there are 500 rows in the master table I could drag down on sub table 1 to cover A1:C500.
The master table will change number of rows on each import, so it may shrink to 400 but most likely grow to 600 and continue growing. What I would like to do is ensure that the various subtables shrink or grow with the row changes in the master sheet.
I could just fill down the sub sheets for 10000 rows but this doesn't seem very efficient.
I'm sure there must be an easy way to link them together but I'm unable to find this.
Any help would be gratefully received.
I have a master table this is created from an export into an excel workbook. This is from a database and has a large number of columns and rows.
From this master table I have a number of other tables which reference the master table. So sub table 1 would ref cell A2, B2, C2 (using the = formula) to create a new table. I can then drag this down to ensure it covers all the rows in the master table. So say that there are 500 rows in the master table I could drag down on sub table 1 to cover A1:C500.
The master table will change number of rows on each import, so it may shrink to 400 but most likely grow to 600 and continue growing. What I would like to do is ensure that the various subtables shrink or grow with the row changes in the master sheet.
I could just fill down the sub sheets for 10000 rows but this doesn't seem very efficient.
I'm sure there must be an easy way to link them together but I'm unable to find this.
Any help would be gratefully received.