Update Formulas in cell using Macro

[vignesh rocks]

Hi Team,

I would like to update the formulas in cell automatically and fill down. Below is my requirement.

1). In Cell D5 update the formula has = C5-B5 and fill down the formula until last row based on Column A

2). In Cell E5 update the formula has = D5/5 and fill down the formula until last row based on Column A

3). In Cell F5 update the formula has = E5/366 and fill down the formula until last row based on Column A

4). In Cell G5 update the formula has =ROUND(IF(M5="",($I$1-E5+1-N5)*J5,IF(M5<>"",(K5-M5+1-N5)*J5)),2) and fill down the formula until last row based on Column A.

Please assist me with this and it would be really appreciated.



Thanks,
Vignesh

[kbkumar]

Hi Vignesh,

when you say "update the formulas in cell automatically and fill down", seems to me that you are looking for a VBA code.

Try the below:

Please Login or Register  to view this content.

Hope this helps.

[vignesh rocks]

Thanks Kumar... It worked perfectly

[kbkumar]

You are welcome, and thanks for the feedback.