I have multiple sheets called Labour, Volulumes and non-Labour. On cell change I am updating cell values to DB.
I have coulmns like vol1, vol2 , vol3 and so on in Volumes sheet. Lab1, Lab2 , Lab3 and so on in Labour sheet. non-lab1, non-lab2, non-lab3 and so on in non-labour sheet.User might create formulas
Example 1. Labour sheet1 => =Volulumes!a5 + a3
So if you consider above example what I want is , If user chnages anything to Volulumes!a5 , it should be saved to Volumes table in database which I am doing on cell change, but the same effect of this change should affect in LAbour sheet also , that sheet value should get chnage and in databse also LAbour table column value should be updated.
can you tell me how to update reference cell value in database on cell change?