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
Very informative for me
Gracias ING por compartirlo 🇲🇽👍
@PowerExbyJitendra
Жыл бұрын
Thanks 🙏🌹
Very helpful and informative video 📹 Thank you sir
@PowerExbyJitendra
Жыл бұрын
Thanks
Thank you sir for giving Precious time and tips
@PowerExbyJitendra
Жыл бұрын
Thanks🙏
Thank you Very Much , I will use it for prepare data of delivery pending payment
Very Very helpful and informative video, Thanks
@PowerExbyJitendra
Жыл бұрын
Thanks
Thank you, sir. It was very helpful to me.
VERY HELPFUL TO CREATE ONE FOR MY EXCEL SHEET WITH FORMULA
Very helpful video, thanks
@PowerExbyJitendra
Жыл бұрын
Thanks
great
Well Explained Sir Thank-you....
@PowerExbyJitendra
7 ай бұрын
Thanks a lot🙏
Sir your every video is very helpful
@PowerExbyJitendra
Жыл бұрын
Thanks
Excellent sir jis chij ki hamen jarurat Hoti hai vahi aap hamen share karte hain thanks so Mach sir 🙏
@PowerExbyJitendra
Жыл бұрын
Thanks
Thank you so much sir very helpful :) (dhanyavaad)
@PowerExbyJitendra
4 ай бұрын
Thanks a lot
Very nice
Thank u sir it is very helpful account maintenance, but sir how to delete mistake entry please clarify sir
Very helpful 😊ty🙏
@PowerExbyJitendra
7 ай бұрын
Thanks
Super...👌
@PowerExbyJitendra
Жыл бұрын
Thanks
thank you sir
@PowerExbyJitendra
Жыл бұрын
Welcome ji
Wow nice
@PowerExbyJitendra
Жыл бұрын
Thanks
Great
@PowerExbyJitendra
7 ай бұрын
Thanks a lot
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.
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 ??
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
Sir muje malti bank cash debit and cash credit kanra kaise kare macro ko samaajme nahi ara sara
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
How to do this in google sheet?
veri helpful
@PowerExbyJitendra
4 ай бұрын
Thanks
@nazmamansuri6011
4 ай бұрын
@@PowerExbyJitendra cannot run the macro debit credit sheet otometk.xlsm lmacro2 is type ka error aa raha hi
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
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
Thanks sir it's very informative but This format not support to mobile
SIR ENTRY EDIT KARANA HO YA DELETE KARNA HO TO...?
इसमे अलग अलग पार्टी के लिए अलग अलग शीट अनुसार के पार्टी का लेजर औटोमेटिक क्रियट हो जाय और उसमे औतोमेटिक डाटा इन्ट्री हो जाया , बिल्कुल tally ओगेरा जैसा उस type कैसे बनता है ?
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%
kya ham mobile me bhibye micro data sheet bana sakte hai
@PowerExbyJitendra
7 ай бұрын
No
Fully Automated Debit And Credit Sheet in Excel | Debit and Credit Sheet in Excel DATA NOT TRANSFER PROPERLY IN ACCOUNTS
Jab bhi new entry kar rahe hai toh woh entry fir row me lera hai sr no. Niche niche nahi continue ho rha
i created macros but not using Paste special option
@PowerExbyJitendra
7 ай бұрын
Please use carefully
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
2 ай бұрын
Same many account in add one sheet help me sir
Hlw sir plzz make a video on macros
@PowerExbyJitendra
Жыл бұрын
I have already videos on Macros please go to channel and watch.
Sir woh file download nahi hoti hai
New entry wapas wapas 2nd me le raha hai
micro enable sheet ko jab ham dusare system pe save karye hai to wo work nahi karta hai kaise kare
@PowerExbyJitendra
7 ай бұрын
Please save this workbook as Excel Macro Enabled Workbook
আপবার ভিডিও দেখে এরকম একটা সিট তৈরি করি কাজ হয় কিন্তু পিসি বন্ধ করলে পরে ওই সফটওয়্যার কাজ করে না
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
Date ko automatically karne k liye kya karna hoga sir
@PowerExbyJitendra
7 ай бұрын
If function ke sath Today function apply karna hoga
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...???
tHis is for record account that called "cash"
@PowerExbyJitendra
7 ай бұрын
Yes
Why didn't reply to my question sir
Hi
@PowerExbyJitendra
7 ай бұрын
Hi
आपके excel sheet को download कैसे और कहाँ से करें सर जी
@PowerExbyJitendra
Жыл бұрын
Downloading link is given in description box
Date bhi automatic karwa dete sir
@PowerExbyJitendra
7 ай бұрын
If cell of serial number is blank then blank other wise Today function Please use like this
Plz share excel sheet
@PowerExbyJitendra
7 ай бұрын
Link is in description.
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
humara data ek jaga pe pest hora
@PowerExbyJitendra
7 ай бұрын
Please use 'Use Relative Reference' while recording Macro
Runtime error 438 आ रही है. Macros काम नहीं कर रहा है. Vba module का मैटर दे दीजिए प्लीज.
@PowerExbyJitendra
Жыл бұрын
Please try again and save file as excel macro enabled workbook
@anantgupta421
Жыл бұрын
@@PowerExbyJitendra micro enable ही save की. पर view मे ही macro run नहीं होता. Object property की error 438 आती है. वीडियो के अनुसार 4 number की transaction ही entry sheet पर नहीं जाती. Excel 2007 है. Quick heal total security भी है.
@sunnychoudhary6917
Жыл бұрын
@@anantgupta421 same problem is to me. Give some solution sir please 🙏
@sunnychoudhary6917
Жыл бұрын
@PowerEx by Jitendra @Anant Gupta same problem is to me. Give some solution sir please 🙏
@sunnychoudhary6917
Жыл бұрын
same problem is to me. Give some solution sir please 🙏
If database sheet is protected, how to write the vba code to unprotec and protec again automatically to record macros.
কাজ করে না
please ap ka contact no di jia