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

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

[@avi130avi130]

same here.. 👍🏻

[@nareshmaneji8122]

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

[@PowerExbyJitendra]

Thanks

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

[@senbiman98]

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

[@avi130avi130]

👌🏻 great tutorial 👏🏻 keep it up.. 👍🏻

[@PowerExbyJitendra]

Thanks a lot

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

[@asimsiddiq475]

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

[@PowerExbyJitendra]

Thanks Asim

[@zainshah8644]

Great teaching methods. From Pakistan

[@PowerExbyJitendra]

Thanks ❤

[@rajpatel4596]

Superb ❤❤❤❤❤ good 👍👍👍

[@aravindkarthik6094]

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

[@Rajumaster]

Excellent topic.. Thank you

[@PowerExbyJitendra]

Welcome

[@rohansen6744]

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

[@PowerExbyJitendra]

You are most welcome🙏

[@mehmoodurrehman9322]

Subscribed and liked it too ❤

[@PowerExbyJitendra]

Thanks a lot

[@CTP2016]

Super B, Best tutorial. Thanks

[@PowerExbyJitendra]

Glad it was helpful!

[@Usmanghani063]

Zabardast! wonderful & unique bro.....

[@PowerExbyJitendra]

Thanks

[@NaveedAhmad-HFD]

Very nice & informative

[@PowerExbyJitendra]

Thanks a lot

[@manjit.sarania]

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

[@PowerExbyJitendra]

Thanks

[@pankajagrawal8546]

😮maza a gya yar

[@Rubelkhan-qx1tx]

Thank you so much nice work

[@PowerExbyJitendra]

Welcome

[@deepakkeshari1168]

You are great Sir

[@PowerExbyJitendra]

Thanks Deepak ji

[@rushiamin1008]

Wonderful ❤

[@PowerExbyJitendra]

Thanks

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

[@shankargaikwad1107]

USEFULL INFORMATION, Thanks

[@Abhijitjitu]

Very good👍

[@PowerExbyJitendra]

Thanks

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

[@ayush112811]

Super , needed exactly the same for my work

[@PowerExbyJitendra]

Thanks

[@rajeshchoudhary2520]

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

[@PowerExbyJitendra]

Thanks

[@NaveedAhmad-HFD]

Thank you so much for sharing

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

[@indian35556]

Wonderful Sir

[@PowerExbyJitendra]

Thanks

[@Mannabhav]

Big fan sir 🙏💐🙏

[@sureshv7724]

Super baiya,

[@motivationt3al]

Thank you so much sir 🙏🙏

[@PowerExbyJitendra]

Welcome🙏

[@dineshtak3363]

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

[@nazmunnaharpriyamoni]

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

[@manjit.sarania]

Very important tricks

[@PowerExbyJitendra]

Thank you so much❤

[@mdmukhlisurrahman9351]

Very nice Thanks

[@PowerExbyJitendra]

You are welcome

[@nagendraprathap9697]

thanks for sharing your valuable knowledge

[@PowerExbyJitendra]

Thanks Nagendra ji

[@jeraldthalaiva85]

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

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

[@saltnpepper1122]

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

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

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

[@rajadey1552]

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

[@virendratiwari3614]

Very good sir

[@PowerExbyJitendra]

Thanks 🙏🙏🙏🙏

[@Amarjit82]

Excellent

[@PowerExbyJitendra]

Thanks

[@NaveedAhmad-HFD]

Tha k you so much

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

[@wahidrashid4865]

Beautiful sir

[@PowerExbyJitendra]

Thanks 🙏

[@bhaskararaodv555]

Super...

[@PowerExbyJitendra]

Thanks

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

[@NaveedAhmad-HFD]

Superb

[@PowerExbyJitendra]

Thanks 🤗

[@DIVYANGMEDIAODIA]

Nice video

[@PowerExbyJitendra]

So nice

[@kavimangalsharma8539]

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

[@deepakarora7478]

Amazing

[@PowerExbyJitendra]

Thanks🙏

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

[@edix_zone850]

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

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

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

[@ArifulIslam-dr4bg]

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

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

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

[@rajatkumaryadav9438]

Super sir

[@PowerExbyJitendra]

Thanks a lot

[@umeshsharma1492]

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

[@KundanFluteArt]

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

[@livegaming5958]

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

[@jethavachandrakant4864]

Sir entri sheet me 200 row select he Aur bad me jyada row kaise kare???

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

[@neilfernandas569]

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

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

[@mohanjoshi5639]

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

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

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

[@rajeshmakwana5515]

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

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

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

[@ammarhaider9881]

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

[@dineshcpathak844]

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

[@itsmesujoy9351]

Small function me kuch kuch number helper me arahe hai but small function me sab nahi a rahe hai

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

[@itsmesujoy9351]

@@PowerExbyJitendra it's ok I will try tomorrow

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

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

[@animalsworld-mb5xd]

How to download those practice file sir

[@PowerExbyJitendra]

Downloading link is given in description box.

[@markandeyagorantala2787]

Sir shall we get products wise details also in this?

[@income_zone1]

Ye same entry Google sheet mei kaise kre?

[@sajadkhanmmd6634]

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

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

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

[@salmsnali786110]

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

[@jethavachandrakant4864]

Aage row jyada select kaise kare

[@sreejamani5802]

Sir, please check there is missing invoice no. 18 ,

[@sreejamani5802]

How to solve

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

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

[@arshad1781]

Nice

[@PowerExbyJitendra]

Thanks

[@ashrafk.m.3936]

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

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

[@jdroy7910]

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

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

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