Hi Meena, i have a similar issue some time ago, where i need to add a formula and update it automatically when i change the content.

The best way to do this its by using legacy fields, that way you wont need to use macros in your document.