Multiple table relation

Tags: #<Tag:0x00007fa98d540e50>

hello,
i have something where two table are interconnected in excel.
for eg. table 1 is about salary and table 2 is about expenses and somewhere in table2 i want to calculate something using values from table1 in formula like “=C9/‘Salary’!C2*‘Tax’!$B$29” .

Hey @edmrepost33

the formula plugin doesn’t support that yet but you can use getDataAtCell/ setDataAtCell methods. Here’s a demo https://jsfiddle.net/1dLzb7st/
I’ve packed the logic into an afterChange hook to get the SUM updated.

2 Likes