Thanks Leo!!!! There is a small modification required in the code.
Call Balance button is not required as I'm trying to get the balance with simple Index formula as shown below
=IFERROR(INDEX(SSR!$B$9:$FU$42,MATCH($F14,SSR!$A$8:$A$42,0),MATCH($G$8&"BAL",SSR!$B$7:$FU$7,0)),"")
Replace Quantity button should be just Quantity, as I'm trying to add the quantity with the existing quantity rather than replacing.
So request you to please make changes and do the needful.
Bookmarks