hey, i have this table (in the image)i want to use the "residual" col values in the "balance " col of the next sheet ... and so on i've tried macro recorder but it dosent work ; the sheet's title in the code dosent change so it get the values of "sheet1" in every new sheet

Last edited by a moderator: