Make list of final balance in another sheet

You can see in the attached file KASHIRAM BHATKAR'S final balance it means last amount in column D in cell D29 is 8600,
YOGESH PACHADE'S final last amount of balance in column H in cell H32 is 5200,
GOPAL GAWANDE'S final last amount of balance in column l in cell L45 is 10000,
ISHWAR SHARMA'S final last amount of balance in column P in cell 40 is 13000, & so on
I want that show that list of final balance it means last amount of balance in sheet2 you can see i do
that manualy , so make list of every person, person name & last amount of balance how do that by VBA
please give me code or apply that code in attached file

You can do it with a couple of formulae - put this in A1 of Sheet2:

=INDEX(Sheet1!$1:$1,(ROWS($1:1)-1)*4+2)&""

and this in B1:

=IF(A1="","",INDEX(Sheet1!$367:$367,(ROWS($1:1)-1)*4+2) - INDEX(Sheet1!$367:$367,(ROWS($1:1)-1)*4+3))

then copy down as required.

Hope this helps.

Pete

Thank you very much , now my problem is solved

Glad to be of help - thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post and mark this thread as SOLVED.

Pete