VBA code to get a column value from the sheet before and so on

[manafn]

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

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1027725-vba-code-get-column-value-sheet-before-so.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.