Added Column Formula in a Spill Range - Cont.

[ScottTemple]

Hello,

I am attempting to connect two tables together, so that when table1 has a new row added, table2 automatically adds that row. While working with @SanjayGMusafir on this site, he was able to assist me with creating a Spill formula into a second tab, in place of a second table (due to errors with Spill data and tables). By taking the Spill data (headers in green), I am adding additional columns that contain formulas that pull from this Spill data (headers in orange).

Either continuing on with this setup or determining how to connect two tables with each other, so that when new rows of data are added to table1, table2 is automatically updated. *My company does not allow me to download third-party add ons, so I am unable to install XL2BB.

Tabe2 or Tab2

 

[Fluff]

My pleasure.

 

[ScottTemple]

Hey Fluff,

Got a quick question for you, I woud like to calculate the difference between cells on different rows in the A2# spill array. In the below example, I would want to calculate the difference between O2 and N3 and the formula I have for that in a normal spreadsheet would be: =IF(N3>=O2,N3-O2,N3+1-2)*1440. I don't know how I can create a formula with the spill array data as they are listed as Index(A2#,,rownumber)

 

[Fluff]

As this is a different question, it needs it's own thread.