Hi All,
I have a workbook with a main sheet with formulas and the values are dependent on the sheets I am adding. I want the sheet with formula to update after I add the sheet where it is dependent. What I actually do now is to double click the cells with formula one by one to get the result. Is there a code that I can place on the main sheet so that after I add a sheet, i will just hit a button to update?