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]

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)

Check this and revert -

Copy and use the formula I gave below and see if they spill...

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)

 

[ScottTemple]

Check this and revert -

Copy and use the formula I gave below and see if they spill...

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)

Unfortunately no, I receive a #REF! error for each formula.

 

[SanjayGMusafir]

Unfortunately no, I receive a #REF! error for each formula.

Then create a new thread to help you with Added Column Formula in a Spill Range

You will get some good help on that

Without XL2BB I have my own constraints to work.

Hope you will understand...

 

[ScottTemple]

Then create a new thread to help you with Added Column Formula in a Spill Range

You will get some good help on that

Without XL2BB I have my own constraints to work.

Hope you will understand...

No worries, you've been great in helping me Sanjay, I very much appreciate it!

 

[SanjayGMusafir]

No worries, you've been great in helping me Sanjay, I very much appreciate it!

Would have enjoyed helping you with last problem too.

Still would look to give Inputs on a new thread, If I would be able to...

 

[ScottTemple]

Would have enjoyed helping you with last problem too.

Still would look to give Inputs on a new thread, If I would be able to...

Lol me too, my new company is unbelievably restrictive on their internet permissions; sometimes I can't even open google.