Total Received colum kya isko automate kar sakte hai. mera ek query hain kya main aapko apna excel file bhej sakta hoon aapke email mei to aap samajh sakte ho kaise karna fix karna hain. aapka video to acha hain bas ek chota sa help chaiye agar aapko main email kar do with detail kya aap samjha sakte ho.
There is a problem in this data sheet when I save name then the code works when I again save more names the code gives error and make a copy of master sheet 😢
When I try to link it shows a notification i.e. "This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator. Please guide me on what I have to do....???
Hello sir Muje video mai thodi help to mili hai per muje ak or requirement thi ki ye data kyo na singal sheet mai likha jaye date to date and ladger mai entry chali jaye and index mai bhi bal show ho
It’s really good but I have a question I am doing this the same but in balance formula i have a problem it keeps saying #REF! And not working can you please say what do I do now
Sir agar vo party ka balance 0 ho gya ho aur hume esa 1 list bnana ho jinse payment lena hai to vo kaise krenge 0 payment walo ko auto remove ho jaye esa kuch.
Hamare customer ledger men agar Kisi party ka excess cash ajae or wo excess cash hamen Kisi or party debit voucher k through Dena ho to usko accounting men kis Tarah solve karenge kindly guide me
Here's an improved code you don't need to change any values you can add as many names as the sheet has: Function create_sheets() Dim i As Long, LastRow As Long Dim wsNames As Worksheet, wsMaster As Worksheet
' Set references to worksheets Set wsNames = ThisWorkbook.Sheets("Names") Set wsMaster = ThisWorkbook.Sheets("Master") ' Activate the Names sheet wsNames.Activate ' Determine the last row in column A of the Names sheet LastRow = wsNames.Cells(wsNames.Rows.Count, "A").End(xlUp).Row ' Loop through the rows in column A of the Names sheet For i = 1 To LastRow
' Copy sheet from template wsMaster.Copy After:=Sheets(Sheets.Count)
' Set a reference to the newly created sheet Dim newSheet As Worksheet Set newSheet = ActiveSheet ' Rename the new sheet based on the value in column A of the Names sheet newSheet.Name = wsNames.Cells(i, 1).Value
' Update cell B2 on the new sheet with its name newSheet.Range("B2").Value = newSheet.Name
Next i
' Display a message when done creating sheets MsgBox "Done creating sheets" End Function
Nice and good, I make it well, but I need some extra act as like, daily sheet and than autocratic transfer into master file and also parties ledger, if you give plz
Improved code: Function create_sheets() Dim i As Long, LastRow As Long Dim wsNames As Worksheet, wsMaster As Worksheet
' Set references to worksheets Set wsNames = ThisWorkbook.Sheets("Names") Set wsMaster = ThisWorkbook.Sheets("Master") ' Activate the Names sheet wsNames.Activate ' Determine the last row in column A of the Names sheet LastRow = wsNames.Cells(wsNames.Rows.Count, "A").End(xlUp).Row ' Loop through the rows in column A of the Names sheet For i = 1 To LastRow
' Copy sheet from template wsMaster.Copy After:=Sheets(Sheets.Count)
' Set a reference to the newly created sheet Dim newSheet As Worksheet Set newSheet = ActiveSheet ' Rename the new sheet based on the value in column A of the Names sheet newSheet.Name = wsNames.Cells(i, 1).Value
' Update cell B2 on the new sheet with its name newSheet.Range("B2").Value = newSheet.Name
Next i
' Display a message when done creating sheets MsgBox "Done creating sheets" End Function
Bhaiya aap ye bataiye agr one year me hm kitne rupees ka turnover kr rhe h to wo hm apne passbook dairy me enter kr hi rhe h to aisa kya kiya jaye ki hme wo turnover ka details sath hi sath count kr ke dikhata jaye ki one year me hm itne rupees ka turnover kr chuke h uske liye kaise excel pr sheet hoga plz ispe video banaye 🙏🙏
Sir jaise apne is sheet main 1 Names wali sheet banai hai aur Os main sirf ek hi Column banaya hai Name ka lakin os k sath second column main kuch aur add ho sakta hai Name k sath jaise k employee ID aur wo master Sheet per kisi aur Column main show honi chahiye agar ho sakta hai to mujhe lazmi reply karna Sir, Thanks 👍
SIR ISME DATA ENTRY KAISE KAREN. YADI HUMNE BANK ME RECEIPT AAYA HAI PARTY SE TOH HUMKO ISME ALAG ALAG JAKAR ENTRY KARNI PAD RAHI HAI. KUCH AISA BATAIYE KI EK BAAR ME PARTY KE ACCOUNT ME AUR BANK ACOOUNT ME ENTRY HO JAYE
Sir maine jaise jaise apki video me bataya waise pura bana liya. Lekin Names me jitne name likhe the waha tak to sab ok h. Par jab m index me koi naya naam add karti hu to aage go par click karne par wo support nhi kar rha h. Sir kya aap please iska solution batayenge.
NIce work sir, But i try this VB code, Run Time error 1004, Application Defined or object-defined error and Master sheet creates master(2) also. how can i correct this sir.
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
Bahut hi accha video h sir. Thanks for sharing
mashallah bohat acha knowlegde sherekia apny
boht acha lga
its really good for me thankyou from pakistan
dear sir please guide after you type b4 who you type GO ?
Pro hai bhai ms excel me🎉
Tu are all videos good sir 🥰👌
Thanks Brother
Just incredible ❤
Thanks Sir apne bahut hi sahi se sam jhaya h
Bahut hi badiya information sir
you describe each and everything very clearly and perfectly... gd going keep it up 👍 👍
Thank you so much 😀
Sir Aapne alt+F11 karne ke baad copy kaise karte hai maine past kiya vo hua hi nahi
Please call me:- 8218429536
@@C-TECH Explain in detail how to make a function sheet. SIR YOU PASTE FUNTION FORMULA
Bank entry how to do only enter one masters sheet and shown particular ledgers
Very Nice 👍
great job its really helpful
Allah aapko Khair de
Good classes namaskar
Hi very informative video until it came to VB. could you tell us how do we write VB codes otherwise after that step we cant do it?
Ser Tansfer hoga ek doseri account me?
Alt + f11 se next wala step mai problem aa rahi hai jisme aap module ke baad paste ki option nahi aa rahi
Pls help
Same problem
Same
Sir i wan to add in this sheet type of payment just like material, labour and transport
To the party. How to do???
Khub sundor hoyeche
Bahut ache se samjhaya sir thanks sir
Thank you sir, i saved ur video for future
Very informative . If you could, please make a playlist of the videos regarding Accounting in Excel. Thank you.
Sir 16:44 par module code apne to type krke rkhe hain lekin hum kaise krein
Formulas
Total Received colum kya isko automate kar sakte hai. mera ek query hain kya main aapko apna excel file bhej sakta hoon aapke email mei to aap samajh sakte ho kaise karna fix karna hain. aapka video to acha hain bas ek chota sa help chaiye agar aapko main email kar do with detail kya aap samjha sakte ho.
Nice video sir, you explain everything very clearly but this line showing error-
ActiveSheet. Name = Sheets("Names").Cell(i, 1)
Same here....even master sheet copied again agian with tbe name of master2, 3, 4......instead of nameliat
Same problem
Same problem Sir
Same problem
Same problem
balance ke liye har baar codding karna hoga kya
Rename wale sheet pr module me kya type krna hai jo apne paste kiya hai
Sir kindly help me at this stage then you insert and copy paste some code you have already practiced i can't understand Please help me about that code
I need help in VBA rebugging i cant get out of the error on create_sheets
a bundle of thanks . this method saves my time.
There is a problem in this data sheet when I save name then the code works when I again save more names the code gives error and make a copy of master sheet 😢
Helpful information 👍👍👍👌👌👌
excellent job, well done love from Pak
Apne jo formula copy past kiya hai VBA me wo kha se milenge
When I try to link it shows a notification i.e. "This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator.
Please guide me on what I have to do....???
Sir BALANCE me formula nahi lag rha h... Amount balance update nahi ho rha h?
Hello sir
Kya isme party add ya delete kr sakte h
Usse other party me koi fark to nhi padega
Please batana
Sir mera tum nai ho raha h
ActiveSheet .Names = Sheets("Names") .Cells (i, 1)
Me problem show kar raha h
❤❤
it’s possible to send this sheet ?? Any updated version of this?? 👍
Aapne es video mei jo bhi bataya hai woh only payment kay liye hai agar kisi ko credit,debit dono karna hoga ik hi a/c mei toh woh kaise karaega
Hello sir
Muje video mai thodi help to mili hai per muje ak or requirement thi ki ye data kyo na singal sheet mai likha jaye date to date and ladger mai entry chali jaye and index mai bhi bal show ho
I want this Excel sheet, how to get this xls sheet.
It’s really good but I have a question I am doing this the same but in balance formula i have a problem it keeps saying #REF! And not working can you please say what do I do now
Posting of day book or cash book to particular ledger account automatically.
=Hyperlink("#'"&B4&"' after that ,this !A1 where it's come ... Could you please explain...
We have to
From which cell you want to link from another sheet
Did you get your answer?
1:16
@navrajdeepsingh6109
Sir agar vo party ka balance 0 ho gya ho aur hume esa 1 list bnana ho jinse payment lena hai to vo kaise krenge 0 payment walo ko auto remove ho jaye esa kuch.
Explain in detail how to make a function sheet. SAME PROBLEM
Thanks bro it's really helps me
what to paste code in visual module kindly let us knowplease
Sir pls same video for google sheet bta dijiye kuki excel me data kai baar save ni hone pr dobara se update krna padta h entry ko.
Jo aapne formula paste kare hai party names wali list ke module mai vo kaha se aayenge
Hamare customer ledger men agar Kisi party ka excess cash ajae or wo excess cash hamen Kisi or party debit voucher k through Dena ho to usko accounting men kis Tarah solve karenge kindly guide me
Here's an improved code you don't need to change any values you can add as many names as the sheet has:
Function create_sheets()
Dim i As Long, LastRow As Long
Dim wsNames As Worksheet, wsMaster As Worksheet
' Set references to worksheets
Set wsNames = ThisWorkbook.Sheets("Names")
Set wsMaster = ThisWorkbook.Sheets("Master")
' Activate the Names sheet
wsNames.Activate
' Determine the last row in column A of the Names sheet
LastRow = wsNames.Cells(wsNames.Rows.Count, "A").End(xlUp).Row
' Loop through the rows in column A of the Names sheet
For i = 1 To LastRow
' Copy sheet from template
wsMaster.Copy After:=Sheets(Sheets.Count)
' Set a reference to the newly created sheet
Dim newSheet As Worksheet
Set newSheet = ActiveSheet
' Rename the new sheet based on the value in column A of the Names sheet
newSheet.Name = wsNames.Cells(i, 1).Value
' Update cell B2 on the new sheet with its name
newSheet.Range("B2").Value = newSheet.Name
Next i
' Display a message when done creating sheets
MsgBox "Done creating sheets"
End Function
How tp make it same in Google Sheet, Please make video for it.
Sir 16:42 pe code Kaha se lia a step samj nai aya
Its amazing.. But hum is ko google sheet main banain tu kiya formula lagana
Alt + f11 laptop Mai nahi ho Raha hai please suggest
Same bhai
Explain in detail how to make a function sheet.
Kia??? Journal ko automatic ledger may kr sktay hay excel may btay😊
Received and payment wala formula break ho rha hai sir kya karu sir mai 7:41
Thanks sir very helpful video sir kafi days bad aayi video sir why reasons
Sorry for that, home construction and 2nd new computer center opening
How to create similar sheet on Google sheets instead of excel
Aesi koi master sheat hai kya jisme ek sheat par click kare or click Kiya hua data uske name se bani huyi sheat par apne aap paunch jaye
Sir VBA court sheet module me jo code lage hain ushko kaise applicable karen
Please help 🙏
ActiveSheet.Name=Sheets("Name").Cells(i,1)
This error sir plz Solve this issue
Sir ,
Aapne names vaali sheet ke baad
Module 1 me pest kon sa formula kiya wo samajh nhi aaya
Module1 par pest nahi ho raha hai please explain
Visual basic me paste karne ke liye matter kaha se lena hota hai
Sir typing k liye laptop best hai ya p.c
Laptop me alag se , keyboard laga lo, kam chal jayega
@@C-TECH ok sir thanks
19:09 space problem nhi hai. wha macro selected nhi hai yni kya run Krna hai wo selected nhi hai.
yes
Hi sir.. I can add 100 customers.. But code error.. It shows as same name cannot be created and template (2)times created..
Same here
Nice video of excel but it's showing an error in the line sheets("MASTER"). copy After:=sheets(i)
Nice and good, I make it well, but I need some extra act as like, daily sheet and than autocratic transfer into master file and also parties ledger, if you give plz
Ap Alt+f11 press karne ke bad kounsa code lagaye he oo to hame pata nhi fir age karnge kya ….
Module me jake pesci katbe ka jo bola aapne o kiya pest karne ka hai sir
Sir
ActivateSheet.Name = Sheets(“NAMES”).Cells(I,1) is showing error kindly help me here
Thanks in advance
If it's error 1004 it's because one of the names in the sheet is written wrong. You can't use special characters.
Improved code:
Function create_sheets()
Dim i As Long, LastRow As Long
Dim wsNames As Worksheet, wsMaster As Worksheet
' Set references to worksheets
Set wsNames = ThisWorkbook.Sheets("Names")
Set wsMaster = ThisWorkbook.Sheets("Master")
' Activate the Names sheet
wsNames.Activate
' Determine the last row in column A of the Names sheet
LastRow = wsNames.Cells(wsNames.Rows.Count, "A").End(xlUp).Row
' Loop through the rows in column A of the Names sheet
For i = 1 To LastRow
' Copy sheet from template
wsMaster.Copy After:=Sheets(Sheets.Count)
' Set a reference to the newly created sheet
Dim newSheet As Worksheet
Set newSheet = ActiveSheet
' Rename the new sheet based on the value in column A of the Names sheet
newSheet.Name = wsNames.Cells(i, 1).Value
' Update cell B2 on the new sheet with its name
newSheet.Range("B2").Value = newSheet.Name
Next i
' Display a message when done creating sheets
MsgBox "Done creating sheets"
End Function
Sir Code not working...?? Many time try but not workings plz help
Bhaiya aap ye bataiye agr one year me hm kitne rupees ka turnover kr rhe h to wo hm apne passbook dairy me enter kr hi rhe h to aisa kya kiya jaye ki hme wo turnover ka details sath hi sath count kr ke dikhata jaye ki one year me hm itne rupees ka turnover kr chuke h uske liye kaise excel pr sheet hoga plz ispe video banaye 🙏🙏
you ara adding deleating but you are not tellng which key where is to click minutely not mensioned about each action
Dear Please I want to Download this sheet suggest me........
Sir me isme automatic interest calculation bhi add krna chahta hu. Ho skta h kya??
ALT+F11 function is not working in Excel
Sir jaise apne is sheet main 1 Names wali sheet banai hai aur Os main sirf ek hi Column banaya hai Name ka lakin os k sath second column main kuch aur add ho sakta hai Name k sath jaise k employee ID aur wo master Sheet per kisi aur Column main show honi chahiye agar ho sakta hai to mujhe lazmi reply karna Sir, Thanks 👍
Thanks for the information but master sheet main insert main jakar table select karane ke bad balance value nahi aa raha hain
Sir, Agar Hum Aur Sheet Barhana Chahe to kiya korne parta
Thanks a lot.you have clearly described each and every thing
Function create_sheet ( ) line isnot working. What should i do
Same problem facing plz help me out..
Sir I’m getting this error Application-defined or object-defined error could you help me to fix this Debug please
Any solution you find
SIR ISME DATA ENTRY KAISE KAREN. YADI HUMNE BANK ME RECEIPT AAYA HAI PARTY SE TOH HUMKO ISME ALAG ALAG JAKAR ENTRY KARNI PAD RAHI HAI. KUCH AISA BATAIYE KI EK BAAR ME PARTY KE ACCOUNT ME AUR BANK ACOOUNT ME ENTRY HO JAYE
Sir maine jaise jaise apki video me bataya waise pura bana liya. Lekin Names me jitne name likhe the waha tak to sab ok h. Par jab m index me koi naya naam add karti hu to aage go par click karne par wo support nhi kar rha h. Sir kya aap please iska solution batayenge.
in names sheet alt+f11 not working so plz help me
I am not able to see all names on the left hand side after playing program. Please guide
Good job sir very good
Nycc bhia koi application h iska
Ye coding use karne par apke Excel par party ke naam se sheets aa rahe hain lekin mere mai master 1, master 2, master 3 karke aa rahe hai aisa ku
Can you make a excel file of bill and balancing together with collection of data
Sar f11 copy Karke pest formula kaise sikhana hai Kaun sa video mein hai
Bhaiya run- time '438':
Object doesn't support this property or method bta rha h
8 no line me
NIce work sir, But i try this VB code, Run Time error 1004, Application Defined or object-defined error and Master sheet creates master(2) also. how can i correct this sir.
Excel sheet pls.... would u pls Mail Excel sheet??
Good sir
Record ke sath invoice bhi manage ho jaye or entry form bhi to bahut badhiya rahega