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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Row 1232[/TD]
[TD]Data[/TD]
[/TR]
[TR]
[TD]Row 1233[/TD]
[TD]Data[/TD]
[/TR]
[TR]
[TD]Row 1234 (New row)[/TD]
[TD]Data[/TD]
[/TR]
</tbody>[/TABLE]



Table 2, 3, etc...; Tab 2
[TABLE="width: 500"]
<tbody>[TR]
[TD]Row 1232[/TD]
[TD]Formula[/TD]
[/TR]
[TR]
[TD]Row 1233[/TD]
[TD]Formula[/TD]
[/TR]
[TR]
[TD]Row 1234 (Automatically inserted when Table 1 Updated)[/TD]
[TD]Formula (Copied Down)[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Row 1232[/TD]
[TD]Formula 2[/TD]
[/TR]
[TR]
[TD]Row 1233[/TD]
[TD]Formula 2[/TD]
[/TR]
[TR]
[TD]Row 1234 (Automatically inserted when Table 1 Updated)[/TD]
[TD]Formula 2 (Copied Down)[/TD]
[/TR]
</tbody>[/TABLE]
etc...