Transfer Data Customer Wise from One Sheet to multiple sheets in excel (Hindi)

In this video you will learn how to transfer customer wise data from one sheet to another without Macro and VBA.
It is setup with simple excel functions - If Function, Vlookup etc.
Important:
There was a mistake in this video. I forgot to fix the cell references inside Small Function used in B2 cell.
The right formula is:
=IFERROR(SMALL($A$2:$A$110,ROWS($B$2:B2)),"")
The file which will be downloaded using link, is correct.
If you find the video valuable please subscribe our channel:
/ powerexbyjitendra
You can download this workbook by clicking on below link:
----------------------------------------------------
docs.google.co...
---------------------------------------------------
Related Videos:
1. IF Function
• If Function in Excel i...
2. IF Function with multiple conditions
• If Function in Excel W...
3. Vlookup
• Vlookup Formula in MS ...
4. Vlookup with Match Function
• How to Use Vlookup wit...
Other Videos on Data Transfer
1. Transfer Data From One Sheet to Multiple Sheets Automatically
• Transfer Data From One...
2. Transfer Data From One Sheet to Multiple Sheets (Other Way)
• Transfer Data From One...
3. How to Automatically Transfer Data from one sheet to another
• How to Automatically T...
Playlists of our top videos:
1. Stock Management System in Excel
• Stock Management Syste...
2. Advanced Excel Formulas
• Advanced Excel Formulas
-----------------------------------------------------------
Gear I Recommend:
-----------------------------------------------------
1. Mice: amzn.to/3I2stPd
2. Mobile Tripod Mount: amzn.to/33gR8kh
3. Gurilla Tripod: amzn.to/3FqwsmT
4. amzn.to/3npWu3C
5. Tripod: amzn.to/3I4P3GV
6. Wireless Bluetooth Headphone: amzn.to/3K8XUcl
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#excel
#powerxbyjitendra
#datatransfer
Subscribe on Telegram:
t.me/powerexby...
Contact Us:
Instagram: ...
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

[@lakpasonamsherpa7079]

Amazing 🙌 This is what I've been looking for It's been hours and finally the best tutorial Just subscribed Hope to learn a lot from your video's

[@PowerExbyJitendra]

Thank you so much❤

[@nareshmaneji8122]

KZbin ka sabse Best video for One Sheet to multiple sheet tq bro

[@PowerExbyJitendra]

Thanks

[@senbiman98]

Very nice and wonderful Sir... you are just master of the Excel. Thanks and hats up to you.

[@NaturalRemidies]

Very nice and productive tutorial! It helps a lot for people who love working in Excle. However, I need such a way where data from multiple sheets goes to customer wise sheet That is one sheet has purchases, other has sales and other has payments and receipts. I need customer wise record from all sheets at one place date wise. please bring a helping tutorial on it if suits. thanks and regards!

[@PowerExbyJitendra]

Thanks for watching and w'll think definitely

[@asimsiddiq475]

Respected sir, you bring us excelent Ms Excel tutorials, I really thanks a lot.

[@PowerExbyJitendra]

Thanks Asim

[@Col.VishalBais]

what an amazing excel trick. Hats off to whoever has made this. Compliments to you Jitendra for sharing. Subscribing you straightaway.

[@PowerExbyJitendra]

Thanks a lot

[@rohansen6744]

Thank you , Sir! for sharing your valuable knowledge so elaborately and in such an easy manner.

[@PowerExbyJitendra]

You are most welcome🙏

[@manjit.sarania]

Excellent formula for data transfer importanc to stock management..🙏

[@PowerExbyJitendra]

Thanks

[@aravindkarthik6094]

FACTS!!!!!! Thank you so much man, you're the best!!!!!!!!!

[@polsonvarkey3924]

First of all I give a NAMASKAR to you for the work you have done, a big salute. I have tried this, but new entries not transfering to other sheets, for the given data it is ok. Pls help on this matter

[@zainshah8644]

Great teaching methods. From Pakistan

[@PowerExbyJitendra]

Thanks ❤

[@deepakkeshari1168]

Very powerful video and helpful inventory management

[@PowerExbyJitendra]

Thanks

[@manjit.sarania]

Super tricks sir..and it helps a lot because I do store management job..🙏

[@PowerExbyJitendra]

Thanks

[@Rajumaster]

Excellent topic.. Thank you

[@PowerExbyJitendra]

Welcome

[@rajpatel4596]

Superb ❤❤❤❤❤ good 👍👍👍

[@CTP2016]

Super B, Best tutorial. Thanks

[@PowerExbyJitendra]

Glad it was helpful!

[@pankajagrawal8546]

😮maza a gya yar

[@mehmoodurrehman9322]

Subscribed and liked it too ❤

[@PowerExbyJitendra]

Thanks a lot

[@totalhyper72]

Very nice & informative

[@PowerExbyJitendra]

Thanks a lot

[@rajeshchoudhary2520]

Nice Video, Non Macro and Non VBA, Automatically data transfer sheet

[@PowerExbyJitendra]

Thanks

[@shankargaikwad1107]

USEFULL INFORMATION, Thanks

[@ayush112811]

Super , needed exactly the same for my work

[@PowerExbyJitendra]

Thanks

[@totalhyper72]

Tha k you so much

[@rushiamin1008]

Wonderful ❤

[@PowerExbyJitendra]

Thanks

[@indian35556]

Wonderful Sir

[@PowerExbyJitendra]

Thanks

[@deepakkeshari1168]

You are great Sir

[@PowerExbyJitendra]

Thanks Deepak ji

[@jeraldthalaiva85]

Sir, pls upload the practice file also easily learn everyone❤❤❤

[@totalhyper72]

Thank you so much for sharing

[@mohanjoshi5639]

Amazing but I got a trouble.... please guide how to change values 'count of ' to 'sum of ' in multiple sheets with single effort.

[@ta20111996]

Zabardast! wonderful & unique bro.....

[@PowerExbyJitendra]

Thanks

[@nagendraprathap9697]

thanks for sharing your valuable knowledge

[@PowerExbyJitendra]

Thanks Nagendra ji

[@Rubelkhan-qx1tx]

Thank you so much nice work

[@PowerExbyJitendra]

Welcome

[@manjit.sarania]

Very important tricks

[@PowerExbyJitendra]

Thank you so much❤

[@Mannabhav]

Big fan sir 🙏💐🙏

[@sureshv7724]

Super baiya,

[@mahipalreddychikalagi2308]

Super sir

[@PowerExbyJitendra]

Thanks🌹

[@bhaskararaodv555]

Super...

[@PowerExbyJitendra]

Thanks

[@umeshsharma1492]

It better if we use advance filter function and convert it to table sheet

[@totalhyper72]

Superb

[@PowerExbyJitendra]

Thanks 🤗

[@umershah1344]

thank you so muxh

[@PowerExbyJitendra]

Welcome

[@umershah1344]

@@PowerExbyJitendra sir ready sheet mil sakti hai because mere pas phone hai cumputer nhi to phone per thora mushkil hai kafi cheeze nhi milti

[@indersingh469]

Great formula,,,,, but what if the invoice no is same for the all company....

[@deepakarora7478]

Amazing

[@PowerExbyJitendra]

Thanks🙏

[@DIVYANGMEDIAODIA]

Nice video

[@PowerExbyJitendra]

So nice

[@Abhijitjitu]

Very good👍

[@PowerExbyJitendra]

Thanks

[@Amarjit82]

Excellent

[@PowerExbyJitendra]

Thanks

[@mdmukhlisurrahman9351]

Very nice Thanks

[@PowerExbyJitendra]

You are welcome

[@motivationt3al]

Thank you so much sir 🙏🙏

[@PowerExbyJitendra]

Welcome🙏

[@s.s1551]

Great Sir Thanks very much for your great effort❤ can we use this format for making ledger??

[@PowerExbyJitendra]

Yes

[@virendratiwari3614]

Very good sir

[@PowerExbyJitendra]

Thanks 🙏🙏🙏🙏

[@wahidrashid4865]

Beautiful sir

[@PowerExbyJitendra]

Thanks 🙏

[@kamalgupta4853]

Kya main data mai se kisi row ko delete karane per dusari sheet mai kya hoga

[@akhtarayub4669]

Greeting sir i am watching to this video since 6 month so that i could not be understand yet.even you are using in which formula they are long.please you kept shortage.

[@PowerExbyJitendra]

You can do it without using any formula: kzbin.info/www/bejne/Z52wq5V5pbiWobcsi=6CfneuAECfX_Ppgw

[@bhargavpanchal1350]

Kya ye pura agre 1 se jiyada row with multiple columns header ke sathe kre tao ho ske ta hai?kyu ki meri sheet me header two rows ke sathe hai so?

[@dineshtak3363]

Sir namaskar, Entry sheet me rows ko add yaa delete kare to results par kya effects hoga

[@bthirupathaiahseety2861]

THANQUE SIR, THIS IS VERY USE FULL SUBJUCT , BUT I AM VERY SORRY TO SAY THAT IN THIS FORMULA EVERY SEPARATED SHEET "ONE ENTRY ENTRY MISSING" IN THIS EXMPLE ALSO N EASY STORE THE INVOICE NO 18 ALSO MISSING PLEASE SOLVE THE PROBLEM AND INFORM TO ALL WITH NOTIFICATION 🙏

[@PowerExbyJitendra]

Actually I forgot to fix cell references inside Small Function. Correct function is: =IFERROR(SMALL($A$2:$A$200,ROWS($B$2:B2)),"") Please consider it as a human Error.

[@ashrafk.m.3936]

This will work only for the existing names, not working with new names.

[@rajadey1552]

Sir small function k replacement m kya sequence function use nhi kar sakte hai?

[@vpremaaa24]

Sir, I have tried this method,all the rquired invoice numbers are reflecting in helper column.But not reflecting in the next column where we use SMALL function.please clarify how to trouble shoot

[@diyanengineeringdesigntuto352]

While small function use one value is missing , in this video 18 is missing

[@rushiamin1008]

Right It may be possible that Some Space is there after "Easy Store "....?!!

[@PowerExbyJitendra]

@@diyanengineeringdesigntuto352 Actually I forgot to fix cell references inside Small Function. Correct function is: =IFERROR(SMALL($A$2:$A$200,ROWS($B$2:B2)),"") Please consider it as a human Error.

[@KundanFluteArt]

Very nice Sir, isme A to Z sort kabhi nahi ho sakta hai, hoga to plz bataye,

[@shareefali395]

This is very good solution but something is wrong intha helper collem shows all not comes in when apply rows function some entries missing in your tutorial also miss 18 no entry please give me this problem solution thanks

[@muhammadfarannadeem1923]

It is very help full .. but i am facing some issues 1. They aren't picking same same serial number if i chose vender . Example Abc vender i buy 2 items with same specifications and i wanna take into one entry number (same serial number like 499) 2. If i use alfa numeric serial . Its also not picking .

[@muhammadfarannadeem1923]

Kindly tell me how to resolve theses issues

[@ArifulIslam-dr4bg]

What to do when single invoice no. For multiple name??

[@saltnpepper1122]

Sir entry sheet Sy Kuch data other sheets per copy nahi hota...Kya waja ho Sakta hy...plz help

[@kavimangalsharma8539]

Sir, if we want to do product wise total in this sheet then how will it be done?

[@tapan4253]

agar cell se sheet ko connect krna ho to kese karenge jismme submit ka button ho or first sheet me jis company ka data fll kiya ussi company ke sheet me save ho jae sirf submit button se

[@nazmunnaharpriyamoni]

Hi dear. Lekin ek customer ek sath 3/4 products purchase karega to ham oche calculate kaise karengge?

[@arshad1781]

Nice

[@PowerExbyJitendra]

Thanks

[@neilfernandas569]

How do I pull data from different sheets based on condition. Approx reverse of this video. Please guide.

[@edix_zone850]

when i entry data but some data not transfer from data entry sheet to other sheet why

[@samirpadhy4368]

Sir if any new vendor came how we will update its individual ledger please inform

[@PowerExbyJitendra]

Copy one of sheets and rename very simple and change customer/vendor name

[@rajeshmakwana5515]

Isme kuch row look up nahi hoti he kya problem hogi sar

[@livegaming5958]

Sir my f4 key does not work when i press screen option then screen select option open

[@adnanshahzad3498]

thanks but some invoices is missing in other sheets may be every 5th entry is not transfer in other sheets

[@mahipalreddychikalagi2308]

Same here

[@mahipalreddychikalagi2308]

He replied pls check

[@spdeotalu]

Can we use DGet Function instead of vlookup and match function

[@PowerExbyJitendra]

Yes

[@ImpossibleBrandy]

I'm unable to download the practice workbook pls help....

[@PowerExbyJitendra]

Please share your mail address my mail address is given in about section

[@markandeyagorantala2787]

Sir shall we get products wise details also in this?

[@baharali7429]

Very helpful information but sir agr kisi customer ka Bill bhi banana ho to wo kesey banay for example invoice no 99 ka bill banana hy to wo kesy bany ga

[@PowerExbyJitendra]

Bahut hi jayaj saval hai

[@baharali7429]

Sir vlookup function or match function lagata hoon to N#A error aajata hy ya agar date ata hy to 00-00-1900 is format m ata hy ye done error kesey khatam hoongy plz reply thanks

[@PowerExbyJitendra]

@@baharali7429 Please see the formula: =IFERROR(VLOOKUP($B2,'Entry Sheet'!$A$3:$I$264,MATCH(E$1,'Entry Sheet'!$A$2:$I$2,0),0),"") and please convert date column in date format

[@baharali7429]

@@PowerExbyJitendra thank you sir I will try and send you results

[@relaxinggospelmusic2421]

😘

[@income_zone1]

Ye same entry Google sheet mei kaise kre?

[@Pashto_song2025]

Sir please make ms excel login screen very sample video 🙏🙏🙏🙏🙏

[@PowerExbyJitendra]

Ok

[@sajadkhanmmd6634]

hi sir my no to issa kia lin entry nahy hota plz

[@ammarhaider9881]

when selecting any cell on Entry sheet, it selects the Table instead of Entry sheet name , please help

[@preetkamal1981]

sir mere serial no is tarh se hai HR00026 rows function kaam nahi kar raha hai iska solution bata do aap

[@PowerExbyJitendra]

Actually I forgot to fix the cell references inside Small Function. Correct Function is: =IFERROR(SMALL($A$2:$A$110,ROWS($B$2:B2)),"") Serial no koi bhi ho no problem

[@Pashto_song2025]

♥♥♥♥

[@PowerExbyJitendra]

Thanks

[@rajeshmakwana5515]

Kuchh number serial me nahi aata aur total match nahi hota he sar to kya problem hogi

[@PowerExbyJitendra]

Actually I forgot to fix cell references inside Small Function. Correct function is: =IFERROR(SMALL($A$2:$A$200,ROWS($B$2:B2)),"") Please consider it as a human Error.

[@dineshcpathak844]

MAIN एंट्री शीट में इनवॉइस नंबर अगर नंबर के अलावा TEXT या कोई स्पेशल symbol है तो कस्टमर इनवॉइस coloun में एरर शो करता है , कृपया समाधान करें ,

[@bhanushali43]

FACING SOME PROBLEM IN EXCLE WORKSHEET AUTOMATIC DATA TRANSFER

[@salmsnali786110]

Sir, you have not attached the worksheet for practice. \

[@jaymistry1412]

It's a mistake. Same date having 2 invoices on the same date.. missing.. Check while putting small function 18 no. Is missing

[@PowerExbyJitendra]

@@jaymistry1412 Correct function is: =IFERROR(SMALL($A$2:$A$200,ROWS($B$2:B2)),"") Please consider it as a human Error.

[@KiranPatel-pw6fs]

Invoice no row may 18 no nahi dhikh raha jo help her vari row me aaya hai

[@PowerExbyJitendra]

@@KiranPatel-pw6fs Correct function is: =IFERROR(SMALL($A$2:$A$200,ROWS($B$2:B2)),"") Please consider it as a human Error.

[@muhammadarif4205]

kuch customer , kuch pay kartay hain ,balance main errer aa jata hey. uper balance theik hota he magar neechay error ajata hain .removeing k liye kiya karain

[@PowerExbyJitendra]

Actually I forgot to fix cell references inside Small Function. Correct function is: =IFERROR(SMALL($A$2:$A$200,ROWS($B$2:B2)),"") Please consider it as a human Error.

[@muhammadarif4205]

sir ap ka invoice no. Theek nhi 2 7 ke bad 18 ana chahiye mager 18 miss ho giya he . helper colum main to theak he mager small function me 18 miss he . isi waja say mera bhi miss ho raha he

[@PowerExbyJitendra]

Actually I forgot to fix cell references inside Small Function. Correct function is: =IFERROR(SMALL($A$2:$A$200,ROWS($B$2:B2)),"") Please consider it as a human Error.

[@jdroy7910]

serial number "4" only not show in small +Rows function

[@ahburana]

Sir, pls fix value of Column A in sheet2.

[@PowerExbyJitendra]

Hello dear, Actually I forgot to fix cell references inside Small Function. Correct function is: =IFERROR(SMALL($A$2:$A$200,ROWS($B$2:B2)),"") Please consider it as a human Error.

[@krashanr]

महोदय ,कृपया शीट नंबर 2 में आइटम नंबर 18 की इंट्री नहीं हुई है ।

[@PowerExbyJitendra]

Actually I forgot to fix cell references inside Small Function. Correct function is: =IFERROR(SMALL($A$2:$A$200,ROWS($B$2:B2)),"") Please consider it as a human Error.

[@tasawarhussainshah7038]

How to create sheets

[@abbasanjam4144]

sir ap ny small farmula lagayya hy is mai 18 invoice ka data kiyo ni aa raha

[@PowerExbyJitendra]

Actually I forgot to fix cell references inside Small Function. Correct function is: =IFERROR(SMALL($A$2:$A$200,ROWS($B$2:B2)),"") Please consider it as a human Error.

[@abbasanjam4144]

thanx sir but aik problem hy k mujy month wise is mai total karna hy tu kaisy kro ga🤔🤔🤔

[@abbasanjam4144]

but thanx sir 😍😍😍😍

[@AjeetSingh-jr4qj]

Ek baar entry karne par multiple time aa rahi h

[@animalsworld-mb5xd]

How to download those practice file sir

[@PowerExbyJitendra]

Downloading link is given in description box.