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

Transfer Data From One Sheet to Multiple Sheets Automatically in excel (Hindi) | Without Macro
In this video you will learn how to transfer data from one sheet to multiple sheets without macro. This is possible because of Excel Pivot Table and a small VBA code of two words.
In our last videos we have used Excel Macros for data transferring.
You can watch this video to know the amazing use of Excel Pivot Table.
-----------------------------------------------------------------------
Download Our Excel Workbook: drive.google.c...
-----------------------------------------------------------------------
Relative Videos:
1. Advance Pivot Table Tips in Hindi
• 12 Useful Excel Pivot ...
2. Multiple Pivot Tables and Slicers in Excel
• Multiple Pivot Tables ...
3.Drop Down List In Excel Hindi
• How To Create Auto Upd...
4. Dependent Drop Down List in Excel
• Dependent Drop Down Li...
____________________________________________
Other Most Popular Videos:
1. Stock Management in Excel (Hindi)
• Stock Management in Ex...
2. How to Create Day Book Report in Excel in Hindi Step by Step
• How to Create Day Book...
3.How to Create Day Book Report in Excel in Hindi Step by Step Part - 2
• How to Create Day Book...
4. How to Create GST Invoice in Excel in Hindi | Tax Invoice Template
• How to create GST Invo...
5. Credit Controlling Sheet in Excel in Hindi
• Credit Controlling She...
6. How to Calculate ROI in Excel (Hindi)
• How to Calculate ROI i...
7. How to Make Letterhead Design in Microsoft Word
• How to Make Letterhead...
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi
#transferdata
#powerxbyjitendra
#excel
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.

[@humaidmihlan1615]

Your teaching method is not too slow or too speed, I can understand your teaching method, I am grateful to you. Thanks.

[@surenderchauhanrajput6505]

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]

New costomer not new sheet so please give proper ans

[@GDCT]

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]

Thanks Danish Bhai

[@bumarani839]

Your teaching very interesting and training knowledge , excellent very grateful

[@PowerExbyJitendra]

Thanks Suresh ji

[@rajeshkumarsharma4752]

Sir, very simple, smooth and effective presentation. Explained like experienced teacher.

[@PowerExbyJitendra]

Thanks a lot

[@mohanjoshi5639]

Thanks. But a problem rised... value came as 'Count of'... how can change value 'count of' to 'Sum of' in multiple sheets..

[@debrajdada]

your explanation is really osm sir. thanks for this nice video.

[@PowerExbyJitendra]

Thanks

[@deepakdalal8731]

Very nice sir jii 👌👌👌

[@RahulKumar-ly6ly]

Thanks sir very helpful video

[@misn24pgs19]

Very helpful Vedio

[@accountanttraining1322]

Zaberdast

[@PowerExbyJitendra]

Thanks

[@Rubelkhan-qx1tx]

Wonderful video

[@PowerExbyJitendra]

Thanks a lot

[@happylife1000]

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]

Need your blessings🙏

[@happylife1000]

@@PowerExbyJitendra you are already doing wonderful job and your channel will keep in flourishing..

[@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

[@sanjuatttri5465]

Good morning sir

[@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

[@rajeshsinghjadham9899]

Thanks sirji good job

[@pujashakya691]

Great

[@PowerExbyJitendra]

Thanks

[@deepakghube]

🙏🏻धन्यवाद 🙏🏻

[@neenaraturi-k1u]

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

[@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

[@Infotainment_official101]

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.

[@chandrakantamaiti7190]

Sir ek sath me 20 product sale karega to stock se - hoyejayega .

[@sanjuatttri5465]

Sir agar. Koi new party add hoti hai to new sheet automatically bane gi kya

[@nagendraprathap9697]

Excellent teaching sir,

[@PowerExbyJitendra]

Thanks Nagendra ji

[@VenkateshV-ou7dt]

Really this is wonderful, was just wondering if there was any option to move these data from sheets to file....(without VBA)

[@TheSmartamin]

Good work , my question is What if i want more then 1 products in same invoice number ?

[@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

[@user-wt8jq3ok7p]

Hi sir...apne party leger me auto sum ka option kese diya.zara plz batade...

[@AnvithMM]

Refresh karne ke liye aap Activeworkbook ke aage kya bola pls bataye

[@SurajPrajapati-jl9sm]

Hi, it's very helpful But will it take auto new sheet for a Clint when I add new clint in master shhet

[@CHANDANSHARMA-dn8wv]

thanks

[@PowerExbyJitendra]

Thanks

[@ArvindKumar-er7lr]

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?

[@sohrabali6080]

Very interesting and very useful topics. Lot of thanks.

[@PowerExbyJitendra]

Thanks

[@yasirbashir2587]

thank you very much. that what I was looking, one question please, if we want to add new costumer?

[@atulbansal3706]

Solution Mila apko?

[@abdulrazackrazack2710]

Hello nice, if I add new store then it will be automatically open new sheet for new store?? Or not

[@paramjeet975singh3]

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]

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??

[@mohanjoshi5639]

How to add new sheet after this process...

[@mdkamal-ol2lx]

sir, ek column ko keon do bara insert kya gya thha fir hide kya gya keon ??

[@Ustechnical1435]

Sir Isme monthwise bhi ho sakta h kya

[@hir312]

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?

[@Nilesh-xo1gf]

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

[@bumarani839]

Hatsup

[@PowerExbyJitendra]

Thanks Bro

[@shoaibnadeemkhokhar]

Sir my my qty 100 type ke hy master sheet py pr other sheet my 1 type hoti hy please guide

[@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.

[@poojashakya2990]

Sir aapne link k liye kya likha h

[@viveckdutt1970]

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]

Dear Vivek, You can design format as per your requirement.

[@satyasadhannag4004]

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.

[@Rubelkhan-qx1tx]

Please help me new data entry but no transfer this party name workbook

[@adishjain8191]

Sir entry automatically fliter sheet Mai update nahi ho rahi hai kuch solution bataiye kaise hogi

[@shaiqicon6827]

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]

Dear Shaiq, I think you should use MS Office above 2010 and window 10 You will really feel the difference

[@amitgarg2310]

is it work when we add more customer name

[@MUHAMMADIMRAN-zw1hh]

But sir if new customer then how it will be add automatically

[@StyleCreation-fm3li]

Show report filter pages ka option show nahi ho raha hai

[@syedghoualishahjilani5103]

How to upload this pivot table file on google sheet .?????

[@ramakantdpochitrakoot5554]

There is Hide show report filter page Please suggest me

[@muhammadnabi5807]

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?

[@Seggy-mw2wf]

Data entry ho gayi he but new party add karni ho to kese kare

[@avinashsinghrathore9664]

Bro if data is in merded cells what to do then

[@khushbushah8429]

What if we have to add new customer

[@rampaudel1981]

New comtumer add kesey add ho gak

[@belimnazir8391]

show rport filter pages nahi dikhata

[@dineshgautam7055]

Sir vidio clear show nahi ho rahi,ye video hd me mil jaygi?

[@PowerExbyJitendra]

Sabhi videos HD mai hai apka net connection check kijiye

[@RakeshSingh-kr9kj]

New customer kaise Add करे

[@Ashokkumar-sp4xh]

How can do this in librecalc office ?

[@parmeshwarmadheshia1865]

Sir If we add new party . Did it automatically updated in new sheet.

[@PowerExbyJitendra]

It's a very valid question. I think you cannot add new customer in this model but I will surely work on it.

[@parmeshwarmadheshia1865]

@@PowerExbyJitendra ok thanks sir Please make a video on this I will wait.

[@susmarai2168]

Sir sheet 1 2 3 jo be hay kharid bikri nafa noksan kasey automatic hojayga?

[@mushtaqafridi6756]

Same question

[@ShopanIslam-k8v]

can you give me this file in excel 2007?please.

[@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%

[@gajendrarawat2258]

Sir how can I add other sheets and how to rename the sheet please help.

[@aatirhussain8782]

Bro Analyze tab ni show hora

[@Rahim12021991]

If need any worksheet. How to create new worksheet with formula?

[@PowerExbyJitendra]

Absur, Are you talking about worksheet used in this video?

[@atuljoshi3317]

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]

Refresh kare

[@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%

[@aditiv37]

any sheet updating will show in master sheet

[@PowerExbyJitendra]

No new sheet will not be updated in master sheet

[@arunkhanal7208]

If a new customer has to Include then?

[@PowerExbyJitendra]

Again very valid question I am working on solution

[@abdulshaikh444]

Save hone ke bad sheet work nahi kar Rahi hai

[@veljibhaimakwana5850]

बाद में नया कस्टमर स्टोर (न्यू पार्टी)ऐड करना हे तो कैसे करे

[@bhagavanpowar9265]

Sir if I will a new customer in master sheet what will result in new ledger?

[@jivanishwarkidenhai.8168]

Please new costomer enter not automatically

[@aatirhussain8782]

How to add new customers??

[@PowerExbyJitendra]

This is very important question. Dear I am working on it

[@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%