Anbuselvam K
Member
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
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