cpendergast
New Member
- Joined
- Sep 9, 2014
- Messages
- 1
I am working on an Excel 2013 workbook that I have to update with a new dataset multiple times a week. The data range frequently changes and requires an unnecessary amount of time to update tables on multiple sheets linked to a master table.
The updated dataset is pulled into the first sheet and formatted as a table. The following sheets have tables that are linked to the Sheet 1 table using this formula: =Table1[#All]
However, if the dataset increases from 103 to 105 rows (or decreases to 100), I have to manually go through the linked tables on the following sheets and add/delete rows. Is there a way to automate the process of altering a linked table's range based on the master table?
Please help! Thank you
The updated dataset is pulled into the first sheet and formatted as a table. The following sheets have tables that are linked to the Sheet 1 table using this formula: =Table1[#All]
However, if the dataset increases from 103 to 105 rows (or decreases to 100), I have to manually go through the linked tables on the following sheets and add/delete rows. Is there a way to automate the process of altering a linked table's range based on the master table?
Please help! Thank you
