Payment and Received Ledger In Microsoft Excel

 Payment and Received Ledger In Microsoft Excel

👉 Create multiple accounts in excel just one click, 

👉 manage your account balance party by party in Microsoft Excel.

👉 Sheet Crate onetime Time saving All Time.

If you want to record your transactions in Excel then this seat is for you,

Like you give money to any party or take money from that party, then you can record it, account will be created in your excel with different party name and balance of all party will be visible to you on main seat, You can also access the account of that party by clicking from the main sheet and enter the transaction entry.

First of all you will prepare a master sheet, you can design according to your need, a design for the sample is given below, you can get an idea from it.👇

Friends when you will make master sheet after that you will design index, in this you will design cell like serial number account head balance and make complete index, For example, you will see a picture below, you can apply ideas from it. 👇

In this seat the code of friend Visual Basic will be used which is given below

Function create_sheets()

    Dim i As Long, LastRow As Long, ws As Worksheet

    

    Sheets("Names").Activate

    

    LastRow = 16

    

    For i = 1 To LastRow

        

        'copy sheet from template

        Sheets("Template").Copy After:=Sheets(i)

        ActiveSheet.Name = Sheets("Names").Cells(i, 1)

        

        'update dc number

        ActiveSheet.Range("b2").Value = ActiveSheet.Name

        

    Next i

    

    MsgBox "Done creating sheets"

    

End Function

If Friends If You Want To Download Demo Seat Then Click On The Link