Channel: C TECH

Category: Science & Technology

Tags: excelexcel by c techlearn excelexcel formulapayment and received ledger

Description: 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. Code:- 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 Practices Sheet :- corelforbeginner.com #excel #passbook #ledgeraccount