Transfer Data From One Sheet to Multiple Sheets Automatically in excel (Hindi) | Without Macro

  Рет қаралды 94,213

PowerEx by Jitendra

PowerEx by Jitendra

Күн бұрын

Пікірлер: 122
@humaidmihlan1615
@humaidmihlan1615 3 жыл бұрын
Your teaching method is not too slow or too speed, I can understand your teaching method, I am grateful to you. Thanks.
@GDCT
@GDCT 4 жыл бұрын
ap ka bohat simple tareka hota hai smjhany ka jo bohat acha hai or achy se smjh mian b aata hai verry good sir
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
Thanks Danish Bhai
@rajeshkumarsharma4752
@rajeshkumarsharma4752 2 жыл бұрын
Sir, very simple, smooth and effective presentation. Explained like experienced teacher.
@PowerExbyJitendra
@PowerExbyJitendra 2 жыл бұрын
Thanks a lot
@bsureshguptha
@bsureshguptha 4 жыл бұрын
Your teaching very interesting and training knowledge , excellent very grateful
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
Thanks Suresh ji
@debrajdada
@debrajdada 2 жыл бұрын
your explanation is really osm sir. thanks for this nice video.
@PowerExbyJitendra
@PowerExbyJitendra 2 жыл бұрын
Thanks
@surenderchauhanrajput6505
@surenderchauhanrajput6505 3 жыл бұрын
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.8168
@jivanishwarkidenhai.8168 2 жыл бұрын
New costomer not new sheet so please give proper ans
@yasirbashir2587
@yasirbashir2587 2 жыл бұрын
thank you very much. that what I was looking, one question please, if we want to add new costumer?
@atulbansal3706
@atulbansal3706 Жыл бұрын
Solution Mila apko?
@deepakdalal8731
@deepakdalal8731 3 жыл бұрын
Very nice sir jii 👌👌👌
@sanjuatttri5465
@sanjuatttri5465 2 жыл бұрын
Good morning sir
@RahulKumar-ly6ly
@RahulKumar-ly6ly 3 жыл бұрын
Thanks sir very helpful video
@happylife1000
@happylife1000 3 жыл бұрын
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..
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Need your blessings🙏
@happylife1000
@happylife1000 3 жыл бұрын
@@PowerExbyJitendra you are already doing wonderful job and your channel will keep in flourishing..
@accountanttraining1322
@accountanttraining1322 2 жыл бұрын
Zaberdast
@PowerExbyJitendra
@PowerExbyJitendra 2 жыл бұрын
Thanks
@Rubelkhan-qx1tx
@Rubelkhan-qx1tx Жыл бұрын
Wonderful video
@PowerExbyJitendra
@PowerExbyJitendra Жыл бұрын
Thanks a lot
@syedghoualishahjilani5103
@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
@nagendraprathap9697
@nagendraprathap9697 4 жыл бұрын
Excellent teaching sir,
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
Thanks Nagendra ji
@rajeshsinghjadham9899
@rajeshsinghjadham9899 4 жыл бұрын
Thanks sirji good job
@misn24pgs19
@misn24pgs19 3 жыл бұрын
Very helpful Vedio
@samirpadhy4368
@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-jl9sm
@SurajPrajapati-jl9sm 2 жыл бұрын
Hi, it's very helpful But will it take auto new sheet for a Clint when I add new clint in master shhet
@deepakghube
@deepakghube 2 жыл бұрын
🙏🏻धन्यवाद 🙏🏻
@AnvithMM
@AnvithMM 2 жыл бұрын
Refresh karne ke liye aap Activeworkbook ke aage kya bola pls bataye
@DandanRaza
@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
@sohrabali6080
@sohrabali6080 3 жыл бұрын
Very interesting and very useful topics. Lot of thanks.
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Thanks
@pujashakya691
@pujashakya691 3 жыл бұрын
Great
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Thanks
@TheSmartamin
@TheSmartamin 3 жыл бұрын
Good work , my question is What if i want more then 1 products in same invoice number ?
@VenkateshV-ou7dt
@VenkateshV-ou7dt 3 жыл бұрын
Really this is wonderful, was just wondering if there was any option to move these data from sheets to file....(without VBA)
@neenaraturi-k1u
@neenaraturi-k1u 5 ай бұрын
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
@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
@Ustechnical1435
@Ustechnical1435 3 жыл бұрын
Sir Isme monthwise bhi ho sakta h kya
@ArvindKumar-er7lr
@ArvindKumar-er7lr 3 жыл бұрын
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
@atulbansal3706 Жыл бұрын
Solution Mila apki?
@atulbansal3706
@atulbansal3706 Жыл бұрын
Apko?
@chandrakantamaiti7190
@chandrakantamaiti7190 3 жыл бұрын
Sir ek sath me 20 product sale karega to stock se - hoyejayega .
@JAMALAIRSERVICES
@JAMALAIRSERVICES Жыл бұрын
Hi sir...apne party leger me auto sum ka option kese diya.zara plz batade...
@abdulrazackrazack2710
@abdulrazackrazack2710 2 жыл бұрын
Hello nice, if I add new store then it will be automatically open new sheet for new store?? Or not
@sanjuatttri5465
@sanjuatttri5465 2 жыл бұрын
Sir agar. Koi new party add hoti hai to new sheet automatically bane gi kya
@mohanjoshi5639
@mohanjoshi5639 Жыл бұрын
Thanks. But a problem rised... value came as 'Count of'... how can change value 'count of' to 'Sum of' in multiple sheets..
@CHANDANSHARMA-dn8wv
@CHANDANSHARMA-dn8wv 2 жыл бұрын
thanks
@PowerExbyJitendra
@PowerExbyJitendra 2 жыл бұрын
Thanks
@EarthLearner462
@EarthLearner462 3 жыл бұрын
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.
@mohanjoshi5639
@mohanjoshi5639 2 жыл бұрын
How to add new sheet after this process...
@muhammadnabi5807
@muhammadnabi5807 3 жыл бұрын
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
@atulbansal3706 Жыл бұрын
Solution Mila apko?
@viveckdutt1970
@viveckdutt1970 4 жыл бұрын
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
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
Dear Vivek, You can design format as per your requirement.
@satyasadhannag4004
@satyasadhannag4004 3 жыл бұрын
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.
@bsureshguptha
@bsureshguptha 4 жыл бұрын
Hatsup
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
Thanks Bro
@shoaibnadeemkhokhar
@shoaibnadeemkhokhar Жыл бұрын
Sir my my qty 100 type ke hy master sheet py pr other sheet my 1 type hoti hy please guide
@samirpadhy4368
@samirpadhy4368 Жыл бұрын
If any new vendor came then how we will update it's ledger separately kindly suggest
@atulbansal3706
@atulbansal3706 Жыл бұрын
Solution Mila apko?
@syedghoualishahjilani5103
@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%
@amitgarg2310
@amitgarg2310 3 жыл бұрын
is it work when we add more customer name
@Nilesh-xo1gf
@Nilesh-xo1gf 3 жыл бұрын
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
@shaiqicon6827
@shaiqicon6827 3 жыл бұрын
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.
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Dear Shaiq, I think you should use MS Office above 2010 and window 10 You will really feel the difference
@mdkamal-ol2lx
@mdkamal-ol2lx Жыл бұрын
sir, ek column ko keon do bara insert kya gya thha fir hide kya gya keon ??
@Rubelkhan-qx1tx
@Rubelkhan-qx1tx Жыл бұрын
Please help me new data entry but no transfer this party name workbook
@hir312
@hir312 2 жыл бұрын
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?
@poojashakya2990
@poojashakya2990 3 жыл бұрын
Sir aapne link k liye kya likha h
@rajthanekarr
@rajthanekarr 2 жыл бұрын
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.
@paramjeet975singh3
@paramjeet975singh3 3 жыл бұрын
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 ..
@shivamdixit381
@shivamdixit381 2 жыл бұрын
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??
@parmeshwarmadheshia1865
@parmeshwarmadheshia1865 4 жыл бұрын
Sir If we add new party . Did it automatically updated in new sheet.
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
It's a very valid question. I think you cannot add new customer in this model but I will surely work on it.
@parmeshwarmadheshia1865
@parmeshwarmadheshia1865 4 жыл бұрын
@@PowerExbyJitendra ok thanks sir Please make a video on this I will wait.
@susmarai2168
@susmarai2168 3 жыл бұрын
Sir sheet 1 2 3 jo be hay kharid bikri nafa noksan kasey automatic hojayga?
@mushtaqafridi6756
@mushtaqafridi6756 3 жыл бұрын
Same question
@khushbushah8429
@khushbushah8429 2 жыл бұрын
What if we have to add new customer
@asadkazmi1308
@asadkazmi1308 Жыл бұрын
sir pls agar iss main new customer add kirna ho to kaisy kirien ?
@syedghoualishahjilani5103
@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%
@gajendrarawat2258
@gajendrarawat2258 10 ай бұрын
Sir how can I add other sheets and how to rename the sheet please help.
@MUHAMMADIMRAN-zw1hh
@MUHAMMADIMRAN-zw1hh Жыл бұрын
But sir if new customer then how it will be add automatically
@ramakantdpochitrakoot5554
@ramakantdpochitrakoot5554 3 жыл бұрын
There is Hide show report filter page Please suggest me
@syedghoualishahjilani5103
@syedghoualishahjilani5103 Жыл бұрын
How to upload this pivot table file on google sheet .?????
@rampaudel1981
@rampaudel1981 10 ай бұрын
New comtumer add kesey add ho gak
@avinashsinghrathore9664
@avinashsinghrathore9664 3 жыл бұрын
Bro if data is in merded cells what to do then
@aditiv37
@aditiv37 3 жыл бұрын
any sheet updating will show in master sheet
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
No new sheet will not be updated in master sheet
@Ashokkumar-sp4xh
@Ashokkumar-sp4xh 3 жыл бұрын
How can do this in librecalc office ?
@StyleCreation-fm3li
@StyleCreation-fm3li Жыл бұрын
Show report filter pages ka option show nahi ho raha hai
@dineshgautam7055
@dineshgautam7055 3 жыл бұрын
Sir vidio clear show nahi ho rahi,ye video hd me mil jaygi?
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Sabhi videos HD mai hai apka net connection check kijiye
@Rahim12021991
@Rahim12021991 4 жыл бұрын
If need any worksheet. How to create new worksheet with formula?
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
Absur, Are you talking about worksheet used in this video?
@adishjain8191
@adishjain8191 3 жыл бұрын
Sir entry automatically fliter sheet Mai update nahi ho rahi hai kuch solution bataiye kaise hogi
@Seggy-mw2wf
@Seggy-mw2wf Жыл бұрын
Data entry ho gayi he but new party add karni ho to kese kare
@arunkhanal7208
@arunkhanal7208 3 жыл бұрын
If a new customer has to Include then?
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Again very valid question I am working on solution
@belimnazir8391
@belimnazir8391 2 жыл бұрын
show rport filter pages nahi dikhata
@atuljoshi3317
@atuljoshi3317 3 жыл бұрын
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
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Refresh kare
@RakeshSingh-kr9kj
@RakeshSingh-kr9kj Жыл бұрын
New customer kaise Add करे
@aatirhussain8782
@aatirhussain8782 3 жыл бұрын
How to add new customers??
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
This is very important question. Dear I am working on it
@veljibhaimakwana5850
@veljibhaimakwana5850 3 жыл бұрын
बाद में नया कस्टमर स्टोर (न्यू पार्टी)ऐड करना हे तो कैसे करे
@bhagavanpowar9265
@bhagavanpowar9265 2 жыл бұрын
Sir if I will a new customer in master sheet what will result in new ledger?
@ShopanIslam-k8v
@ShopanIslam-k8v 5 ай бұрын
can you give me this file in excel 2007?please.
@aatirhussain8782
@aatirhussain8782 3 жыл бұрын
Bro Analyze tab ni show hora
@jivanishwarkidenhai.8168
@jivanishwarkidenhai.8168 2 жыл бұрын
Please new costomer enter not automatically
@abdulshaikh444
@abdulshaikh444 2 жыл бұрын
Save hone ke bad sheet work nahi kar Rahi hai
@prasadvsatya2700
@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
@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%
Transfer Data From One Sheet to Multiple Sheets Automatically in Excel (Hindi)
15:33
To Brawl AND BEYOND!
00:51
Brawl Stars
Рет қаралды 17 МЛН
Правильный подход к детям
00:18
Beatrise
Рет қаралды 11 МЛН
Transfer Data Customer Wise from One Sheet to multiple sheets in excel (Hindi)
21:01
Efficiently Transfer Data from One Sheet to Multiple Sheets in Excel
15:20
PowerEx by Jitendra
Рет қаралды 14 М.
Try The DGET Function Instead of INDEXMATCH & XLOOKUP
12:29
Kenji Explains
Рет қаралды 141 М.
Обучение EXCEL. УРОК 9: Умные таблицы EXCEL (динамический диапазон, DATA TABLES).
16:09
Return Multiple Match Results in Excel (2 methods)
14:13
Leila Gharani
Рет қаралды 1,9 МЛН
🔥 Quickly Combine Data from Multiple Sheets into One (new way)
5:02
To Brawl AND BEYOND!
00:51
Brawl Stars
Рет қаралды 17 МЛН