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❤

[@deepakkeshari1168]

You are great Sir

[@PowerExbyJitendra]

Thanks Deepak ji

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

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

[@sampoornaswadesi3491]

PLEASE CHECK ALL NUMBERS ARE NOT COMING

[@PowerExbyJitendra]

Dear Subscriber, 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.

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

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

[@anshabhi4325]

How is this possible if I just put the invoice no in another sheet and some selected data which we want in another sheet automatically paste from one sheet to another

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

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

[@mohanjoshi5639]

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

[@ashrafk.m.3936]

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

[@edix_zone850]

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

[@umeshsharma1492]

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

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

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

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

[@PrimeHexa]

This is very long process dude. Why don't you use filter farmula instead? It's just so easy dude.

[@TheRajasekar03]

Filter formula won't available in Microsoft 2016

[@AjeetSingh-jr4qj]

Ek baar entry karne par multiple time aa rahi h

[@shreeram-ci4kw]

Invoice no madhe

[@mbmanoj6910]

vai serial to thik nai...18 number to asani serial a

[@razaali8230]

Bahijan 18 wali invoice nhe i qq

[@sreejithkrishnan1111]

sir, Helper colum(show 18 value) Invoice No. colum (Not show 18 value) 18 Missing check it sir help me pls Time line 10.05

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

[@sreejithkrishnan1111]

Thanks...

[@income_zone1]

Ye same entry Google sheet mei kaise kre?

[@kamalgupta4853]

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

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

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

[@dineshcpathak844]

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

[@rajpatel4596]

Superb ❤❤❤❤❤ good 👍👍👍

[@shreeram-ci4kw]

Helper colam madhil 18no ala nshi

[@sajadkhanmmd6634]

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

[@indersingh469]

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

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

[@tasawarhussainshah7038]

How to create sheets

[@neilfernandas569]

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

[@ArifulIslam-dr4bg]

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

[@jeraldthalaiva85]

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

[@totalhyper72]

Tha k you so much

[@bhanushali43]

FACING SOME PROBLEM IN EXCLE WORKSHEET AUTOMATIC DATA TRANSFER

[@Sharafathossain-g9o]

WHY INVOICE NUMBER 18 IS MISSING?

[@PowerExbyJitendra]

@@Sharafathossain-g9o 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)),"")

[@saltnpepper1122]

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

[@senbiman98]

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

[@jdroy7910]

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

[@luvdahake4936]

Sorry but invoice number 18 bhi easy store hai wo filter nahi hua

[@PowerExbyJitendra]

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

[@salmsnali786110]

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

[@rajadey1552]

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

[@animalsworld-mb5xd]

How to download those practice file sir

[@PowerExbyJitendra]

Downloading link is given in description box.

[@kavimangalsharma8539]

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

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

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

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

[@raghunandanshukla9497]

Cc😊.

[@mehmoodurrehman9322]

Subscribed and liked it too ❤

[@PowerExbyJitendra]

Thanks a lot

[@muhammadarif4205]

sir

[@chabidhara5368]

Small function me A19 cell selection nehi hua

[@livegaming5958]

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

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

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

ggg

[@ammarhaider9881]

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

[@rajeshmakwana5515]

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

[@KundanFluteArt]

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

[@dineshtak3363]

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

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

[@relaxinggospelmusic2421]

😘

[@Rajumaster]

Excellent topic.. Thank you

[@PowerExbyJitendra]

Welcome

[@aravindkarthik6094]

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

[@totalhyper72]

Thank you so much for sharing

[@muhammadarif4205]

easy store ki 18 no entry show nhi ho rhi. is ki kiya waja 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.

[@rajeshsurvase4759]

Invoice no 18 not showing

[@PowerExbyJitendra]

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

[@shreeram-ci4kw]

Helper colam me18no invoice no me nahi aya

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

[@rajeshchoudhary2520]

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

[@PowerExbyJitendra]

Thanks

[@ashishyadav-gg9yl]

Can u place share this sheet

[@PowerExbyJitendra]

Downloading link is given in description box.

[@kashrafali2258]

SMALL FUNCTION IS NOT WORKING PROPERLY. HAVE YOU EVER NOTED IT

[@PowerExbyJitendra]

Yes sir I noted it I mention a note in description box. Actually I forgot to fix the cell references inside Small Function. Correct Function is: =IFERROR(SMALL($A$2:$A$110,ROWS($B$2:B2)),"")

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

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

[@Pashto_song2025]

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

[@PowerExbyJitendra]

Ok

[@manjit.sarania]

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

[@PowerExbyJitendra]

Thanks

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

[@ta20111996]

Zabardast! wonderful & unique bro.....

[@PowerExbyJitendra]

Thanks

[@tayyabpervez2608]

Sir this is not working

[@Sharafathossain-g9o]

INVOICE NUMBER 18 IS MISSING.

[@PowerExbyJitendra]

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

[@PowerExbyJitendra]

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

[@CTP2016]

Super B, Best tutorial. Thanks

[@PowerExbyJitendra]

Glad it was helpful!

[@rushiamin1008]

Wonderful ❤

[@PowerExbyJitendra]

Thanks

[@markandeyagorantala2787]

Sir shall we get products wise details also in this?

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

[@pankajagrawal8546]

😮maza a gya yar

[@nareshmaneji8122]

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

[@PowerExbyJitendra]

Thanks

[@s.s1551]

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

[@PowerExbyJitendra]

Yes

[@spdeotalu]

Can we use DGet Function instead of vlookup and match function

[@PowerExbyJitendra]

Yes

[@indian35556]

Wonderful Sir

[@PowerExbyJitendra]

Thanks

[@zainshah8644]

Great teaching methods. From Pakistan

[@PowerExbyJitendra]

Thanks ❤

[@kashrafali2258]

OPERATION SUCCESS BUT PATIENT DIED. RESULT THEEK NAHI HAI. SMALL FUNCTION JO RESULT DE RAHA HAI USKO GOUR KAREN

[@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)),"") This is a human error.

[@Mannabhav]

Big fan sir 🙏💐🙏

[@mahipalreddychikalagi2308]

Super sir

[@PowerExbyJitendra]

Thanks🌹

[@nagendraprathap9697]

thanks for sharing your valuable knowledge

[@PowerExbyJitendra]

Thanks Nagendra ji

[@deepakarora7478]

Amazing

[@PowerExbyJitendra]

Thanks🙏

[@totalhyper72]

Superb

[@PowerExbyJitendra]

Thanks 🤗