Auto Update Between Two Tables (Adding Rows/Columns)

[ScottTemple]

Hello,

I have two tables on two separate tabs within the same workbook, labelled SHData and SHCOData. When I add new rows, columns and data to SHData I would like that data to populate in the SHCOData table, new rows/columns and data included. Only some of the data from SHData will need to be brought over to SHCOData though.

I've researched this topic online, however, I can only find reference to some VBA codes and either Power Pivot or Power Query, none of which has been able to answer my question.

 

[SanjayGMusafir]

Got blank message above

 

[ScottTemple]

So I added a new row to SHData table and it appeared as a new row in the Spill area of the SHCOData tab, but the formulas I had in the SHCOData tab did not fill out to include that new row (column J & L in row 520):

 

[SanjayGMusafir]

So I added a new row to SHData table and it appeared as a new row in the Spill are of the SHCOData tab, but the formulas I had in the SHCOData tab did not fill out to include that new row (column J & L in row 520):

Share XL2BB of this sheet and I shall correct the formulae to spill with array

 

[ScottTemple]

Share XL2BB of this sheet and I shall correct the formulae to spill with array

Sorry what is XL2BB?

 

[SanjayGMusafir]

Sorry what is XL2BB?

See the link below in my signatures to help you

That is how we share information on this forum

 

[ScottTemple]

Did a quick google search, unfortunately, my company blocks almost all downloads and I'm not able to install this zip file. Is there another way I can provide these formulas to you?

See the link below in my signatures to help you

That is how we share information on this forum

 

[SanjayGMusafir]

Did a quick google search, unfortunately, my company blocks almost all downloads and I'm not able to install this zip file. Is there another way I can provide these formulas to you?

Then type the exact formula you are using in the first row of the data - I try to help you in some way, If I can

 

[ScottTemple]

Then type the exact formula you are using in the first row of the data - I try to help you in some way, If I can

Here are the three formulas for columns J, K, L. Column J references another tab that determines Density based on Grade (second photo):

View attachment 104410

Sheet8!

Also, the Spill data returns a value of 0 when there is a blank in the SHData tab, this unforutnately causes a #DIV/0! error in column L which will prevent me from SUM'ing that column's total and will interfer with pivot table results. Is there a way around this?

 

[SanjayGMusafir]

Here are the three formulas for columns J, K, L. Column J references another tab that determines Density based on Grade (second photo):

View attachment 104410

Sheet8!

Also, the Spill data returns a value of 0 when there is a blank in the SHData tab, this unforutnately causes a #DIV/0! error in column L which will prevent me from SUM'ing that column's total and will interfer with pivot table results. Is there a way around this?

View attachment 104413

Share only formula

Can't do anything with Screenshot and all

 

[ScottTemple]

Share only formula

Can't do anything with Screenshot and all

Column J: =XLOOKUP(B2,Sheet8!$E$2:$E$8,Sheet8!$F$2:$F$8)
Column K; =SUM(C2*C2)*1.517
Column L: =IF(E2="","",(((F2*4)/3.14)/(J2*(C2^2)))/12)