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

  Рет қаралды 91,702

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 3 жыл бұрын
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 3 жыл бұрын
Thanks Danish Bhai
@bumarani839
@bumarani839 3 жыл бұрын
Your teaching very interesting and training knowledge , excellent very grateful
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Thanks Suresh ji
@rajeshkumarsharma4752
@rajeshkumarsharma4752 Жыл бұрын
Sir, very simple, smooth and effective presentation. Explained like experienced teacher.
@PowerExbyJitendra
@PowerExbyJitendra Жыл бұрын
Thanks a lot
@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
@debrajdada
@debrajdada 2 жыл бұрын
your explanation is really osm sir. thanks for this nice video.
@PowerExbyJitendra
@PowerExbyJitendra 2 жыл бұрын
Thanks
@RahulKumar-ly6ly
@RahulKumar-ly6ly 3 жыл бұрын
Thanks sir very helpful video
@deepakdalal8731
@deepakdalal8731 3 жыл бұрын
Very nice sir jii 👌👌👌
@nagendraprathap9697
@nagendraprathap9697 3 жыл бұрын
Excellent teaching sir,
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Thanks Nagendra ji
@Rubelkhan-qx1tx
@Rubelkhan-qx1tx 11 ай бұрын
Wonderful video
@PowerExbyJitendra
@PowerExbyJitendra 11 ай бұрын
Thanks a lot
@misn24pgs19
@misn24pgs19 3 жыл бұрын
Very helpful Vedio
@rajeshsinghjadham9899
@rajeshsinghjadham9899 3 жыл бұрын
Thanks sirji good job
@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
@sanjuatttri5465
@sanjuatttri5465 2 жыл бұрын
Good morning sir
@deepakghube
@deepakghube 2 жыл бұрын
🙏🏻धन्यवाद 🙏🏻
@pujashakya691
@pujashakya691 2 жыл бұрын
Great
@PowerExbyJitendra
@PowerExbyJitendra 2 жыл бұрын
Thanks
@mohanjoshi5639
@mohanjoshi5639 Жыл бұрын
Thanks. But a problem rised... value came as 'Count of'... how can change value 'count of' to 'Sum of' in multiple sheets..
@VenkateshV-ou7dt
@VenkateshV-ou7dt 2 жыл бұрын
Really this is wonderful, was just wondering if there was any option to move these data from sheets to file....(without VBA)
@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
@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?
@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
@neenaraturi-k1u
@neenaraturi-k1u 22 күн бұрын
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
@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
@TheSmartamin
@TheSmartamin 2 жыл бұрын
Good work , my question is What if i want more then 1 products in same invoice number ?
@CHANDANSHARMA-dn8wv
@CHANDANSHARMA-dn8wv 2 жыл бұрын
thanks
@PowerExbyJitendra
@PowerExbyJitendra 2 жыл бұрын
Thanks
@JAMALAIRSERVICES
@JAMALAIRSERVICES 9 ай бұрын
Hi sir...apne party leger me auto sum ka option kese diya.zara plz batade...
@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
@chandrakantamaiti7190
@chandrakantamaiti7190 2 жыл бұрын
Sir ek sath me 20 product sale karega to stock se - hoyejayega .
@AnvithMM
@AnvithMM 2 жыл бұрын
Refresh karne ke liye aap Activeworkbook ke aage kya bola pls bataye
@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?
@mohanjoshi5639
@mohanjoshi5639 Жыл бұрын
How to add new sheet after this process...
@sohrabali6080
@sohrabali6080 2 жыл бұрын
Very interesting and very useful topics. Lot of thanks.
@PowerExbyJitendra
@PowerExbyJitendra 2 жыл бұрын
Thanks
@Infotainment_official101
@Infotainment_official101 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.
@Rubelkhan-qx1tx
@Rubelkhan-qx1tx 11 ай бұрын
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
@sanjuatttri5465
@sanjuatttri5465 2 жыл бұрын
Sir agar. Koi new party add hoti hai to new sheet automatically bane gi kya
@abdulrazackrazack2710
@abdulrazackrazack2710 2 жыл бұрын
Hello nice, if I add new store then it will be automatically open new sheet for new store?? Or not
@mdkamal-ol2lx
@mdkamal-ol2lx Жыл бұрын
sir, ek column ko keon do bara insert kya gya thha fir hide kya gya keon ??
@bumarani839
@bumarani839 3 жыл бұрын
Hatsup
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Thanks Bro
@Ustechnical1435
@Ustechnical1435 3 жыл бұрын
Sir Isme monthwise bhi ho sakta h kya
@rampaudel1981
@rampaudel1981 6 ай бұрын
New comtumer add kesey add ho gak
@Rubelkhan-qx1tx
@Rubelkhan-qx1tx 11 ай бұрын
Please help me new data entry but no transfer this party name workbook
@viveckdutt1970
@viveckdutt1970 3 жыл бұрын
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 3 жыл бұрын
Dear Vivek, You can design format as per your requirement.
@satyasadhannag4004
@satyasadhannag4004 2 жыл бұрын
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.
@shoaibnadeemkhokhar
@shoaibnadeemkhokhar 9 ай бұрын
Sir my my qty 100 type ke hy master sheet py pr other sheet my 1 type hoti hy please guide
@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?
@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??
@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
@rajthanekarr
@rajthanekarr Жыл бұрын
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.
@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
@paramjeet975singh3
@paramjeet975singh3 2 жыл бұрын
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 ..
@poojashakya2990
@poojashakya2990 2 жыл бұрын
Sir aapne link k liye kya likha h
@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?
@MUHAMMADIMRAN-zw1hh
@MUHAMMADIMRAN-zw1hh 10 ай бұрын
But sir if new customer then how it will be add automatically
@StyleCreation-fm3li
@StyleCreation-fm3li Жыл бұрын
Show report filter pages ka option show nahi ho raha hai
@amitgarg2310
@amitgarg2310 3 жыл бұрын
is it work when we add more customer name
@ramakantdpochitrakoot5554
@ramakantdpochitrakoot5554 3 жыл бұрын
There is Hide show report filter page Please suggest me
@adishjain8191
@adishjain8191 3 жыл бұрын
Sir entry automatically fliter sheet Mai update nahi ho rahi hai kuch solution bataiye kaise hogi
@RakeshSingh-kr9kj
@RakeshSingh-kr9kj Жыл бұрын
New customer kaise Add करे
@syedghoualishahjilani5103
@syedghoualishahjilani5103 Жыл бұрын
How to upload this pivot table file on google sheet .?????
@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 6 ай бұрын
Sir how can I add other sheets and how to rename the sheet please help.
@Seggy-mw2wf
@Seggy-mw2wf Жыл бұрын
Data entry ho gayi he but new party add karni ho to kese kare
@Ashokkumar-sp4xh
@Ashokkumar-sp4xh 3 жыл бұрын
How can do this in librecalc office ?
@belimnazir8391
@belimnazir8391 2 жыл бұрын
show rport filter pages nahi dikhata
@khushbushah8429
@khushbushah8429 2 жыл бұрын
What if we have to add new customer
@avinashsinghrathore9664
@avinashsinghrathore9664 2 жыл бұрын
Bro if data is in merded cells what to do then
@dineshgautam7055
@dineshgautam7055 2 жыл бұрын
Sir vidio clear show nahi ho rahi,ye video hd me mil jaygi?
@PowerExbyJitendra
@PowerExbyJitendra 2 жыл бұрын
Sabhi videos HD mai hai apka net connection check kijiye
@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%
@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
@aditiv37
@aditiv37 3 жыл бұрын
any sheet updating will show in master sheet
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
No new sheet will not be updated in master sheet
@veljibhaimakwana5850
@veljibhaimakwana5850 3 жыл бұрын
बाद में नया कस्टमर स्टोर (न्यू पार्टी)ऐड करना हे तो कैसे करे
@bhagavanpowar9265
@bhagavanpowar9265 2 жыл бұрын
Sir if I will a new customer in master sheet what will result in new ledger?
@parmeshwarmadheshia1865
@parmeshwarmadheshia1865 3 жыл бұрын
Sir If we add new party . Did it automatically updated in new sheet.
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
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 3 жыл бұрын
@@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 2 жыл бұрын
Same question
@ShopanIslam-k8v
@ShopanIslam-k8v 25 күн бұрын
can you give me this file in excel 2007?please.
@Rahim12021991
@Rahim12021991 3 жыл бұрын
If need any worksheet. How to create new worksheet with formula?
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Absur, Are you talking about worksheet used in this video?
@arunkhanal7208
@arunkhanal7208 3 жыл бұрын
If a new customer has to Include then?
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Again very valid question I am working on solution
@jivanishwarkidenhai.8168
@jivanishwarkidenhai.8168 2 жыл бұрын
Please new costomer enter not automatically
@aatirhussain8782
@aatirhussain8782 3 жыл бұрын
How to add new customers??
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
This is very important question. Dear I am working on it
@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%
@aatirhussain8782
@aatirhussain8782 3 жыл бұрын
Bro Analyze tab ni show hora
@abdulshaikh444
@abdulshaikh444 2 жыл бұрын
Save hone ke bad sheet work nahi kar Rahi hai
Transfer Data From One Sheet to Multiple Sheets Automatically in Excel (Hindi)
15:33
Transfer data Automatically in excel sheet | No VBA and NO Macro
10:17
Новый уровень твоей сосиски
00:33
Кушать Хочу
Рет қаралды 4,1 МЛН
SHAPALAQ 6 серия / 3 часть #aminkavitaminka #aminak #aminokka #расулшоу
00:59
Аминка Витаминка
Рет қаралды 283 М.
Fully Automated Data Entry User Form in Excel - Step By Step Tutorial
35:41
EASILY Make an Automated Data Entry Form in Excel |
9:56
Expert Solutions & Services Providers
Рет қаралды 44 М.
10 Excel Formula used daily at WORK (Excel formula for job interview)
13:52
Automatic Data Transfer From One Sheet To Another in Excel
6:12
MRB Tech Solutions
Рет қаралды 43 М.
Excel automatically save data another sheet without coding
6:24
SAHU Tuber
Рет қаралды 555 М.
Новый уровень твоей сосиски
00:33
Кушать Хочу
Рет қаралды 4,1 МЛН