Automatically Insert Rows in Dependent Table

[gsheridan]

Hello,

I have 2 data tables that get updated and carried forward every month. I have another tab that essentially has each table stacked on top of each other 8 times, with formulas and links to the data tables. When I insert new rows to the data tables, I would like the rows automatically inserted into the linking/formula tab, and if possible the formulas copied down. Currently when I insert a new data row, I then have to insert a row and copy the formulas down 16 times.

Is it possible to insert a row into the data table, and have the linking/formula tab have rows automatically inserted? Or is it possible to make the tables in the linking/formula tab dependent on the data table, especially with them being stacked on top of each other?

 

[Rhodie72]

Hello,

I have 2 data tables that get updated and carried forward every month. I have another tab that essentially has each table stacked on top of each other 8 times, with formulas and links to the data tables. When I insert new rows to the data tables, I would like the rows automatically inserted into the linking/formula tab, and if possible the formulas copied down. Currently when I insert a new data row, I then have to insert a row and copy the formulas down 16 times.

Is it possible to insert a row into the data table, and have the linking/formula tab have rows automatically inserted? Or is it possible to make the tables in the linking/formula tab dependent on the data table, especially with them being stacked on top of each other?

show us an example of what you are trying to do

 

[gsheridan]

Thank you for the response.

I have Table 1 in tab 1. There are 1233 rows of data. I insert a row of data to make Table 1 have 1234 rows of data.

I have 8 Tables in tab 2, stacked on top of each other. These tables reference Table 1, are 1233 rows, and have unique formulas. When I insert a row in Table 1 to make it 1234 rows, I would like excel to automatically make each of the tables in tab 2 to have 1234 rows, preferably with their formulas copied down.

Please let me know if this example is unclear. Thank you for your help.

 

[gsheridan]

Table 1; Tab 1

Row 1232	Data
Row 1233	Data
Row 1234 (New row)	Data

<tbody>
</tbody>

Table 2, 3, etc...; Tab 2

Row 1232	Formula
Row 1233	Formula
Row 1234 (Automatically inserted when Table 1 Updated)	Formula (Copied Down)

<tbody>
</tbody>

Row 1232	Formula 2
Row 1233	Formula 2
Row 1234 (Automatically inserted when Table 1 Updated)	Formula 2 (Copied Down)

<tbody>
</tbody>

etc...