• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Adding a row in excel table need to add a row in next tables

Dear Excel Genius

I have a excel workbook having 3 tables in one sheet name called "Production"

Table 1, Product_Formulation
Table 2 Consumption
Table 3 Cost_Calcu

Table 2 and Table 3 data updated from table1 with formulas. But I don't know how to activate them.

For example, As per below snapshot, I added data in the row 50 and 51 of the table1. How can I get auto added the same row and it's calculation in the table2 and table3?

I attached the excel sheet here.

Note: I am using Windows Office 365