I am very new to Excel macro and need help with the below.

I have a nested json string as below.

{{"Version":1,"CVersion":0,"Adjustment":19,"stock":{"Rate":1.41,"Price":19},"units":[{"Place":"NW","unitId":2,"depart":[1,2],"Usage":[{"fuel":"gas","Rate":19},{"fuel":"disel","Rate":19}],"ip":[{"fuel":"gas","aCoef":19},{"fuel":"disel","aCoef":2]},{"Plcae":"London","unitId":2,"depart":[1,2],"usage":[{"fuel":"liquid","Rate":19}]"Price":{"Rate1":19,"Rate2":19}}]}

I have flattened it as below in the excel.

whenever I update any row in the value column in excel I need a new json in cell E with the updated value .
For Instance when I update adjustment value as 45 in the excel sheet,when I run a marco I want VBA code to generate a new json with the updated value as 45 for adjustment.Please provide inputs.
Thank you.