Your teaching method is not too slow or too speed, I can understand your teaching method, I am grateful to you. Thanks.
@GDCT4 жыл бұрын
ap ka bohat simple tareka hota hai smjhany ka jo bohat acha hai or achy se smjh mian b aata hai verry good sir
@PowerExbyJitendra4 жыл бұрын
Thanks Danish Bhai
@rajeshkumarsharma47522 жыл бұрын
Sir, very simple, smooth and effective presentation. Explained like experienced teacher.
@PowerExbyJitendra2 жыл бұрын
Thanks a lot
@bsureshguptha4 жыл бұрын
Your teaching very interesting and training knowledge , excellent very grateful
@PowerExbyJitendra4 жыл бұрын
Thanks Suresh ji
@debrajdada2 жыл бұрын
your explanation is really osm sir. thanks for this nice video.
@PowerExbyJitendra2 жыл бұрын
Thanks
@surenderchauhanrajput65053 жыл бұрын
Sir, your teaching method is good but in master sheet, we entry new customer, but party ledger ke sath sare party ledger create hote h, jabki only one create hona chahiye, jo pahle se create h vo party ledger nahi hone chahiye, so please update me if possible
@jivanishwarkidenhai.81682 жыл бұрын
New costomer not new sheet so please give proper ans
@yasirbashir25872 жыл бұрын
thank you very much. that what I was looking, one question please, if we want to add new costumer?
@atulbansal3706 Жыл бұрын
Solution Mila apko?
@deepakdalal87313 жыл бұрын
Very nice sir jii 👌👌👌
@sanjuatttri54652 жыл бұрын
Good morning sir
@RahulKumar-ly6ly3 жыл бұрын
Thanks sir very helpful video
@happylife10003 жыл бұрын
Thanks for this video, VBA coding which you shared is really v helpful. Thanks for sharing in detail..pls keep uploading more and more such videos..
@PowerExbyJitendra3 жыл бұрын
Need your blessings🙏
@happylife10003 жыл бұрын
@@PowerExbyJitendra you are already doing wonderful job and your channel will keep in flourishing..
@accountanttraining13222 жыл бұрын
Zaberdast
@PowerExbyJitendra2 жыл бұрын
Thanks
@Rubelkhan-qx1tx Жыл бұрын
Wonderful video
@PowerExbyJitendra Жыл бұрын
Thanks a lot
@syedghoualishahjilani5103 Жыл бұрын
I am using this from last 2 year . Bcoz of ur superb way of teach i easily prepared that sheet. Now i want to update sheet on google sheet. I tried but it doesn't work on it. Kindly advice plz
@nagendraprathap96974 жыл бұрын
Excellent teaching sir,
@PowerExbyJitendra4 жыл бұрын
Thanks Nagendra ji
@rajeshsinghjadham98994 жыл бұрын
Thanks sirji good job
@misn24pgs193 жыл бұрын
Very helpful Vedio
@samirpadhy4368 Жыл бұрын
Sir thanks for reply but my question if we add new party after doing all the previous update then how can update the new party ledger
@SurajPrajapati-jl9sm2 жыл бұрын
Hi, it's very helpful But will it take auto new sheet for a Clint when I add new clint in master shhet
@deepakghube2 жыл бұрын
🙏🏻धन्यवाद 🙏🏻
@AnvithMM2 жыл бұрын
Refresh karne ke liye aap Activeworkbook ke aage kya bola pls bataye
@DandanRaza Жыл бұрын
Sir master sheet agar new entry ese karain jo uper nhi ho to ese men new sheet banjaegi ? me ne koshish ki he leken new sheet nhi ban rehi kindly guide me
@sohrabali60803 жыл бұрын
Very interesting and very useful topics. Lot of thanks.
@PowerExbyJitendra3 жыл бұрын
Thanks
@pujashakya6913 жыл бұрын
Great
@PowerExbyJitendra3 жыл бұрын
Thanks
@TheSmartamin3 жыл бұрын
Good work , my question is What if i want more then 1 products in same invoice number ?
@VenkateshV-ou7dt3 жыл бұрын
Really this is wonderful, was just wondering if there was any option to move these data from sheets to file....(without VBA)
@neenaraturi-k1u5 ай бұрын
Sir ji ek agar hama work iska opposite karna hoo ki alag alag customers ma entry ho or wo master sheet par bi update hoo
@Rubelkhan-qx1tx Жыл бұрын
I have 1 questions when I am submit totally new customer details I mean don't master sheet then to post new cerate workbook please tell me
@Ustechnical14353 жыл бұрын
Sir Isme monthwise bhi ho sakta h kya
@ArvindKumar-er7lr3 жыл бұрын
Sir is it possible in day to day reporting where item are sometimes different from the previous one. If itemwise worksheet created and some new item added in master sheet then how to update the relevent sheet. kindly update
@atulbansal3706 Жыл бұрын
Solution Mila apki?
@atulbansal3706 Жыл бұрын
Apko?
@chandrakantamaiti71903 жыл бұрын
Sir ek sath me 20 product sale karega to stock se - hoyejayega .
@JAMALAIRSERVICES Жыл бұрын
Hi sir...apne party leger me auto sum ka option kese diya.zara plz batade...
@abdulrazackrazack27102 жыл бұрын
Hello nice, if I add new store then it will be automatically open new sheet for new store?? Or not
@sanjuatttri54652 жыл бұрын
Sir agar. Koi new party add hoti hai to new sheet automatically bane gi kya
@mohanjoshi5639 Жыл бұрын
Thanks. But a problem rised... value came as 'Count of'... how can change value 'count of' to 'Sum of' in multiple sheets..
@CHANDANSHARMA-dn8wv2 жыл бұрын
thanks
@PowerExbyJitendra2 жыл бұрын
Thanks
@EarthLearner4623 жыл бұрын
Dear Jitender I already watched your macro based worksheet data entry video but I have one question. How to use that same macro which was assign to save data entry video in the dashboard sheet to enter data on multiple sheets from time to time. For example I want data entry for sheet named as April. Likewise I want to use that same macro to enter data for other months on the same workbook.
@mohanjoshi56392 жыл бұрын
How to add new sheet after this process...
@muhammadnabi58073 жыл бұрын
Aoa Bro ita a good video i like it but i have a question how we add a new costumer in this table kindly resolve my issue thanks
@atulbansal3706 Жыл бұрын
Solution Mila apko?
@viveckdutt19704 жыл бұрын
Sir it is an excellent way of maintaining ledger , but can you add the option of payment into it , it will make easy for us too. Waiting for your response
@PowerExbyJitendra4 жыл бұрын
Dear Vivek, You can design format as per your requirement.
@satyasadhannag40043 жыл бұрын
Dear Jitender, the video has been successfully come into force, but fresh entry is not being updated. Please give reply. One reason may be that new row is not being taken by pivot table. Please reply to overcome the difficulty to auto update the individual named worhsheet while making refresh. Even now I did not save by macro enabled workbook.
@bsureshguptha4 жыл бұрын
Hatsup
@PowerExbyJitendra4 жыл бұрын
Thanks Bro
@shoaibnadeemkhokhar Жыл бұрын
Sir my my qty 100 type ke hy master sheet py pr other sheet my 1 type hoti hy please guide
@samirpadhy4368 Жыл бұрын
If any new vendor came then how we will update it's ledger separately kindly suggest
@atulbansal3706 Жыл бұрын
Solution Mila apko?
@syedghoualishahjilani5103 Жыл бұрын
It's very simple copy sheet of a previous customer and add on new sheet. Than on the top on left side . Change customer name . It's work 100%
@amitgarg23103 жыл бұрын
is it work when we add more customer name
@Nilesh-xo1gf3 жыл бұрын
sir agar exel sheet 3 4 ho or vhi sari sheeto me kaam ak hi kiya ho data same he lekin charo sheet me aadhe aadhe data he to fir un charo sheet ko milake master sheer yani sab data merge kaise kre plz uska vdo bnaye
@shaiqicon68273 жыл бұрын
We, in office, use Window 7 with Office 10 but I think there are some features missing so please let me know which office addition will fulfill the requirements.
@PowerExbyJitendra3 жыл бұрын
Dear Shaiq, I think you should use MS Office above 2010 and window 10 You will really feel the difference
@mdkamal-ol2lx Жыл бұрын
sir, ek column ko keon do bara insert kya gya thha fir hide kya gya keon ??
@Rubelkhan-qx1tx Жыл бұрын
Please help me new data entry but no transfer this party name workbook
@hir3122 жыл бұрын
Can I prepare same Master Sheet for products so that details of products supplied are shown Under Customers' names? And can these both Master Sheets be linked?
@poojashakya29903 жыл бұрын
Sir aapne link k liye kya likha h
@rajthanekarr2 жыл бұрын
Hi My task is to create data for 10 Users and update in to 10 different files for their work that too every day. So i need something which can copy pest the Master sheet data to 10 user files below their existing data. Please help.
@paramjeet975singh33 жыл бұрын
Sir mere pas 10 sheets hai... Kya aysa ho sakta hai... Refresh only sheet 1 se sheet 5 tak hi refresh ho...... Muje sabhi sheets ko refresh ni karnaa ..
@shivamdixit3812 жыл бұрын
I need one help. I have one sheet in which data comes from another sheet. In this new sheet there are some data blank in 1 row (suppose row 'X"). I want only filled data from that "X" row with all other rows & column to another sheet automatically. How can it be done??
@parmeshwarmadheshia18654 жыл бұрын
Sir If we add new party . Did it automatically updated in new sheet.
@PowerExbyJitendra4 жыл бұрын
It's a very valid question. I think you cannot add new customer in this model but I will surely work on it.
@parmeshwarmadheshia18654 жыл бұрын
@@PowerExbyJitendra ok thanks sir Please make a video on this I will wait.
@susmarai21683 жыл бұрын
Sir sheet 1 2 3 jo be hay kharid bikri nafa noksan kasey automatic hojayga?
@mushtaqafridi67563 жыл бұрын
Same question
@khushbushah84292 жыл бұрын
What if we have to add new customer
@asadkazmi1308 Жыл бұрын
sir pls agar iss main new customer add kirna ho to kaisy kirien ?
@syedghoualishahjilani5103 Жыл бұрын
It's very simple copy sheet of a previous customer and add on new sheet. Than on the top on left side . Change customer name . It's work 100%
@gajendrarawat225810 ай бұрын
Sir how can I add other sheets and how to rename the sheet please help.
@MUHAMMADIMRAN-zw1hh Жыл бұрын
But sir if new customer then how it will be add automatically
@ramakantdpochitrakoot55543 жыл бұрын
There is Hide show report filter page Please suggest me
@syedghoualishahjilani5103 Жыл бұрын
How to upload this pivot table file on google sheet .?????
@rampaudel198110 ай бұрын
New comtumer add kesey add ho gak
@avinashsinghrathore96643 жыл бұрын
Bro if data is in merded cells what to do then
@aditiv373 жыл бұрын
any sheet updating will show in master sheet
@PowerExbyJitendra3 жыл бұрын
No new sheet will not be updated in master sheet
@Ashokkumar-sp4xh3 жыл бұрын
How can do this in librecalc office ?
@StyleCreation-fm3li Жыл бұрын
Show report filter pages ka option show nahi ho raha hai
@dineshgautam70553 жыл бұрын
Sir vidio clear show nahi ho rahi,ye video hd me mil jaygi?
@PowerExbyJitendra3 жыл бұрын
Sabhi videos HD mai hai apka net connection check kijiye
@Rahim120219914 жыл бұрын
If need any worksheet. How to create new worksheet with formula?
@PowerExbyJitendra4 жыл бұрын
Absur, Are you talking about worksheet used in this video?
@adishjain81913 жыл бұрын
Sir entry automatically fliter sheet Mai update nahi ho rahi hai kuch solution bataiye kaise hogi
@Seggy-mw2wf Жыл бұрын
Data entry ho gayi he but new party add karni ho to kese kare
@arunkhanal72083 жыл бұрын
If a new customer has to Include then?
@PowerExbyJitendra3 жыл бұрын
Again very valid question I am working on solution
@belimnazir83912 жыл бұрын
show rport filter pages nahi dikhata
@atuljoshi33173 жыл бұрын
1/4/20se31/03/21 tak ka data master sheet par hai kintu piviot table se jo multi sheet bani hai usme 1/1/21 tak ka data hi show ho raha hai please give me sugation
@PowerExbyJitendra3 жыл бұрын
Refresh kare
@RakeshSingh-kr9kj Жыл бұрын
New customer kaise Add करे
@aatirhussain87823 жыл бұрын
How to add new customers??
@PowerExbyJitendra3 жыл бұрын
This is very important question. Dear I am working on it
@veljibhaimakwana58503 жыл бұрын
बाद में नया कस्टमर स्टोर (न्यू पार्टी)ऐड करना हे तो कैसे करे
@bhagavanpowar92652 жыл бұрын
Sir if I will a new customer in master sheet what will result in new ledger?
@ShopanIslam-k8v5 ай бұрын
can you give me this file in excel 2007?please.
@aatirhussain87823 жыл бұрын
Bro Analyze tab ni show hora
@jivanishwarkidenhai.81682 жыл бұрын
Please new costomer enter not automatically
@abdulshaikh4442 жыл бұрын
Save hone ke bad sheet work nahi kar Rahi hai
@prasadvsatya2700 Жыл бұрын
Nice but uncomplete so i dont satisfied by ur analyse let me know how to enter new customer in same sheet it's not working when we enter any new customer.
@syedghoualishahjilani5103 Жыл бұрын
It's very simple copy sheet of a previous customer and add on new sheet. Than on the top on left side . Change customer name . It's work 100%