Fully Automated Debit And Credit Sheet in Excel | Debit and Credit Sheet in Excel

Fully Automated Debit And Credit Sheet in Excel | Debit and Credit Sheet in Excel
If you want to create a fully automated debit and credit sheet like a software, you must watch this video.
Follow the steps explained in the video and create it.
✅For more videos please subscribe our channel: / powerexbyjitendra
And if you want to download our file, click on below link: ==============================
drive.google.com/file/d/1aCzw...
==============================
Playlists of our top videos:
1. Stock Management System in Excel
• Stock Management Syste...
2. Advanced Excel Formulas
• Advanced Excel Formulas
3. Awesome MS Word Videos
• MS Word
4. Conditional Formatting in Excel
• Conditional Formatting
5. Data Entry Form
• Data Entry Forms
6. Custom Number Formatting Tricks
• Custom Number Formatting
7. Recent Uploads
• Recent Uploaded Videos
------------------------------------------------------------------
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#debitandcredit
#powerexbyjitendra
#excel
Subscribe on Telegram:
t.me/powerexbyjitendra
Contact Us:
Instagram: kumarjitendra11...
Facebook : / powerex-by-jitendra-10...
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.
Fair use is a permitted by copyright statute that might otherwise be infringing.
Non-profit, educational or personal use tips the balance in favor of fair use.
Thanks

Пікірлер: 94

  • @dailyfun1586
    @dailyfun1586 Жыл бұрын

    Very informative for me

  • @grijalvaescobedo158
    @grijalvaescobedo158 Жыл бұрын

    Gracias ING por compartirlo 🇲🇽👍

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thanks 🙏🌹

  • @baharali7429
    @baharali7429 Жыл бұрын

    Very helpful and informative video 📹 Thank you sir

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thanks

  • @intekhabalam687
    @intekhabalam687 Жыл бұрын

    Thank you sir for giving Precious time and tips

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thanks🙏

  • @farmasia2889
    @farmasia28894 ай бұрын

    Thank you Very Much , I will use it for prepare data of delivery pending payment

  • @ibrahimaluva652
    @ibrahimaluva652 Жыл бұрын

    Very Very helpful and informative video, Thanks

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thanks

  • @chathurasampath3184
    @chathurasampath3184 Жыл бұрын

    Thank you, sir. It was very helpful to me.

  • @rangass70
    @rangass703 ай бұрын

    VERY HELPFUL TO CREATE ONE FOR MY EXCEL SHEET WITH FORMULA

  • @mubeenmomin7170
    @mubeenmomin7170 Жыл бұрын

    Very helpful video, thanks

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thanks

  • @kashifqasim8069
    @kashifqasim8069 Жыл бұрын

    great

  • @YashSharma-hf1vx
    @YashSharma-hf1vx7 ай бұрын

    Well Explained Sir Thank-you....

  • @PowerExbyJitendra

    @PowerExbyJitendra

    7 ай бұрын

    Thanks a lot🙏

  • @alkaarora5722
    @alkaarora5722 Жыл бұрын

    Sir your every video is very helpful

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thanks

  • @gsincubatormaharashtra3967
    @gsincubatormaharashtra3967 Жыл бұрын

    Excellent sir jis chij ki hamen jarurat Hoti hai vahi aap hamen share karte hain thanks so Mach sir 🙏

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thanks

  • @ranjithkumar-yv3xk
    @ranjithkumar-yv3xk4 ай бұрын

    Thank you so much sir very helpful :) (dhanyavaad)

  • @PowerExbyJitendra

    @PowerExbyJitendra

    4 ай бұрын

    Thanks a lot

  • @muhammadirfan.au6572
    @muhammadirfan.au657220 күн бұрын

    Very nice

  • @hanumanthappad5122
    @hanumanthappad5122 Жыл бұрын

    Thank u sir it is very helpful account maintenance, but sir how to delete mistake entry please clarify sir

  • @mayurikale1606
    @mayurikale16067 ай бұрын

    Very helpful 😊ty🙏

  • @PowerExbyJitendra

    @PowerExbyJitendra

    7 ай бұрын

    Thanks

  • @Camaraderie.
    @Camaraderie. Жыл бұрын

    Super...👌

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thanks

  • @Bhaskar_Deva
    @Bhaskar_Deva Жыл бұрын

    thank you sir

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Welcome ji

  • @atalchamlingrai7117
    @atalchamlingrai7117 Жыл бұрын

    Wow nice

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thanks

  • @DKDocuments
    @DKDocuments9 ай бұрын

    Great

  • @PowerExbyJitendra

    @PowerExbyJitendra

    7 ай бұрын

    Thanks a lot

  • @wahidul.islam09
    @wahidul.islam092 ай бұрын

    This is very helpful video. I have made this in my PC. But why is it just saving in C Drive? Why is it not saving in the any other Drive of the PC? And at the time of saving this is always showing : "Be careful! Parts of your Document may include personal information that can't be removed by the document inspector". Please reply.

  • @hsbdailyshow3197
    @hsbdailyshow3197 Жыл бұрын

    outstanding zabardast .... i was searching this type of automatic application in excel But what if i want to add entries to different customers with different names and want to keep account ledgers record of each customers separately is it possible ??

  • @afriditechnicalskill4997
    @afriditechnicalskill49975 ай бұрын

    sir kindly 11:28 pe ap ne jo Formula Bar select kia howa hai wo kaisy kia howa hai yaha mery sath select nahe ho para

  • @nayazahamedma2936
    @nayazahamedma29362 ай бұрын

    Sir muje malti bank cash debit and cash credit kanra kaise kare macro ko samaajme nahi ara sara

  • @zubairanjum2941
    @zubairanjum29416 ай бұрын

    Dear boht achi video he me ne sara buna liya thanks ,but aik option or bata de k ager is data entry ko save k sath aik print b daina ho to uska b bata de

  • @ThwarikhAnvar
    @ThwarikhAnvar Жыл бұрын

    How to do this in google sheet?

  • @nazmamansuri6011
    @nazmamansuri60114 ай бұрын

    veri helpful

  • @PowerExbyJitendra

    @PowerExbyJitendra

    4 ай бұрын

    Thanks

  • @nazmamansuri6011

    @nazmamansuri6011

    4 ай бұрын

    @@PowerExbyJitendra cannot run the macro debit credit sheet otometk.xlsm lmacro2 is type ka error aa raha hi

  • @nayazahamedma2936
    @nayazahamedma29362 ай бұрын

    3 ya 4 accout ko debet and credite karne ka ek entry me so kaise kare sir record macro samaj me nahi ara sir. Help me bahuth use hoga muje account ke liye

  • @inforetailer_RohitKumar
    @inforetailer_RohitKumar Жыл бұрын

    Sir ek excel esi file banaiye jisme search box ho or search box me hum jo bhi search kare usme hum jo edit kare vo data sheet par change ho jaye. Plz plz plz

  • @natarajraj8208
    @natarajraj82082 ай бұрын

    Thanks sir it's very informative but This format not support to mobile

  • @PravinWakode77
    @PravinWakode775 ай бұрын

    SIR ENTRY EDIT KARANA HO YA DELETE KARNA HO TO...?

  • @DineshSigdel
    @DineshSigdel Жыл бұрын

    इसमे अलग अलग पार्टी के लिए अलग अलग शीट अनुसार के पार्टी का लेजर औटोमेटिक क्रियट हो जाय और उसमे औतोमेटिक डाटा इन्ट्री हो जाया , बिल्कुल tally ओगेरा जैसा उस type कैसे बनता है ?

  • @infomaster1805
    @infomaster1805 Жыл бұрын

    EMI multiple rate calculator kasay bana sakty hn. For example: Loan Amount: 1 Million 500,000 markup rate 5% 250,000 markup rate 6% 250,000 markup rate 7%

  • @sunitachaurasiya3207
    @sunitachaurasiya320710 ай бұрын

    kya ham mobile me bhibye micro data sheet bana sakte hai

  • @PowerExbyJitendra

    @PowerExbyJitendra

    7 ай бұрын

    No

  • @alihamid962
    @alihamid962 Жыл бұрын

    Fully Automated Debit And Credit Sheet in Excel | Debit and Credit Sheet in Excel DATA NOT TRANSFER PROPERLY IN ACCOUNTS

  • @fahad9144
    @fahad9144 Жыл бұрын

    Jab bhi new entry kar rahe hai toh woh entry fir row me lera hai sr no. Niche niche nahi continue ho rha

  • @thariqmtq4921
    @thariqmtq4921 Жыл бұрын

    i created macros but not using Paste special option

  • @PowerExbyJitendra

    @PowerExbyJitendra

    7 ай бұрын

    Please use carefully

  • @aalerazi9975
    @aalerazi99754 ай бұрын

    Sir, Please make a sheet with double entry system sheet. for example if we debit salary expense Rs.5000 and Credit Cash in hand Rs.5000. and after many entries our balance sheet and profit and loss account will automatically manage

  • @nayazahamedma2936

    @nayazahamedma2936

    2 ай бұрын

    Same many account in add one sheet help me sir

  • @Deepukumar-td4kc
    @Deepukumar-td4kc Жыл бұрын

    Hlw sir plzz make a video on macros

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    I have already videos on Macros please go to channel and watch.

  • @sameerabbas14
    @sameerabbas14 Жыл бұрын

    Sir woh file download nahi hoti hai

  • @fahad9144
    @fahad9144 Жыл бұрын

    New entry wapas wapas 2nd me le raha hai

  • @sunitachaurasiya3207
    @sunitachaurasiya320710 ай бұрын

    micro enable sheet ko jab ham dusare system pe save karye hai to wo work nahi karta hai kaise kare

  • @PowerExbyJitendra

    @PowerExbyJitendra

    7 ай бұрын

    Please save this workbook as Excel Macro Enabled Workbook

  • @shahjahanali5189
    @shahjahanali51896 ай бұрын

    আপবার ভিডিও দেখে এরকম একটা সিট তৈরি করি কাজ হয় কিন্তু পিসি বন্ধ করলে পরে ওই সফটওয়্যার কাজ করে না

  • @kasandapatrick1762
    @kasandapatrick1762 Жыл бұрын

    hi there Mr. Jitendra, i do a've a request , please consider preparing your videos in english language. because some of your esteemed subscribers don't understand Hindi

  • @jassimakhter4515
    @jassimakhter45157 ай бұрын

    Date ko automatically karne k liye kya karna hoga sir

  • @PowerExbyJitendra

    @PowerExbyJitendra

    7 ай бұрын

    If function ke sath Today function apply karna hoga

  • @meremaheboobkayamathogi8326
    @meremaheboobkayamathogi8326Ай бұрын

    Running balance ke entire cells me 4500 likha hua aaya.... kya un used cells ko blank kar sakte hai... ??? Formula =if lagake... kaise kar sakte hai...???

  • @setyaningsajekti
    @setyaningsajekti9 ай бұрын

    tHis is for record account that called "cash"

  • @PowerExbyJitendra

    @PowerExbyJitendra

    7 ай бұрын

    Yes

  • @nayazahamedma2936
    @nayazahamedma29362 ай бұрын

    Why didn't reply to my question sir

  • @muhammadrafiq4249
    @muhammadrafiq42498 ай бұрын

    Hi

  • @PowerExbyJitendra

    @PowerExbyJitendra

    7 ай бұрын

    Hi

  • @padmalochanpatel2502
    @padmalochanpatel2502 Жыл бұрын

    आपके excel sheet को download कैसे और कहाँ से करें सर जी

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Downloading link is given in description box

  • @Arshleenkaur1609
    @Arshleenkaur1609 Жыл бұрын

    Date bhi automatic karwa dete sir

  • @PowerExbyJitendra

    @PowerExbyJitendra

    7 ай бұрын

    If cell of serial number is blank then blank other wise Today function Please use like this

  • @jkcomputerjalkot2118
    @jkcomputerjalkot21189 ай бұрын

    Plz share excel sheet

  • @PowerExbyJitendra

    @PowerExbyJitendra

    7 ай бұрын

    Link is in description.

  • @krmotion1522
    @krmotion1522 Жыл бұрын

    Sir ji , nice tricks..... Sir ji ek question: "I was try to create simple data entry file . Employee information : Name /address/gender/Birthday dates/ joining date / Designation / contact number * Command button * Click Command button to open VBA userform * Fill data in userform * Save data in Table formats * Anything serachable box making (How to data entry using userform for Table ?????????) Please sir biggest helps for office employees & Database mantain

  • @Mdrana-xd9tk
    @Mdrana-xd9tk9 ай бұрын

    humara data ek jaga pe pest hora

  • @PowerExbyJitendra

    @PowerExbyJitendra

    7 ай бұрын

    Please use 'Use Relative Reference' while recording Macro

  • @anantgupta421
    @anantgupta421 Жыл бұрын

    Runtime error 438 आ रही है. Macros काम नहीं कर रहा है. Vba module का मैटर दे दीजिए प्लीज.

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Please try again and save file as excel macro enabled workbook

  • @anantgupta421

    @anantgupta421

    Жыл бұрын

    @@PowerExbyJitendra micro enable ही save की. पर view मे ही macro run नहीं होता. Object property की error 438 आती है. वीडियो के अनुसार 4 number की transaction ही entry sheet पर नहीं जाती. Excel 2007 है. Quick heal total security भी है.

  • @sunnychoudhary6917

    @sunnychoudhary6917

    Жыл бұрын

    @@anantgupta421 same problem is to me. Give some solution sir please 🙏

  • @sunnychoudhary6917

    @sunnychoudhary6917

    Жыл бұрын

    @PowerEx by Jitendra @Anant Gupta same problem is to me. Give some solution sir please 🙏

  • @sunnychoudhary6917

    @sunnychoudhary6917

    Жыл бұрын

    same problem is to me. Give some solution sir please 🙏

  • @jayanthamadasekera8248
    @jayanthamadasekera82486 ай бұрын

    If database sheet is protected, how to write the vba code to unprotec and protec again automatically to record macros.

  • @shahjahanali5189
    @shahjahanali51896 ай бұрын

    কাজ করে না

  • @Goku_GAMING4
    @Goku_GAMING4Күн бұрын

    please ap ka contact no di jia

Келесі