Hi Arkish,

My apologies that I could not reply you earlier.
Check the attached macro, I have done is I have taken formula from cell E5 and use the same formula for cell E7. Check whether this is what you want:


Attachment :
Book3.xlsm


Regards,
Paresh J