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❤

[@nareshmaneji8122]

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

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

[@manjit.sarania]

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

[@PowerExbyJitendra]

Thanks

[@zainshah8644]

Great teaching methods. From Pakistan

[@PowerExbyJitendra]

Thanks ❤

[@deepakkeshari1168]

Very powerful video and helpful inventory management

[@PowerExbyJitendra]

Thanks

[@mehmoodurrehman9322]

Subscribed and liked it too ❤

[@PowerExbyJitendra]

Thanks a lot

[@deepakkeshari1168]

You are great Sir

[@PowerExbyJitendra]

Thanks Deepak ji

[@rajpatel4596]

Superb ❤❤❤❤❤ good 👍👍👍

[@asimsiddiq475]

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

[@PowerExbyJitendra]

Thanks Asim

[@Usmanghani063]

Zabardast! wonderful & unique bro.....

[@PowerExbyJitendra]

Thanks

[@manjit.sarania]

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

[@PowerExbyJitendra]

Thanks

[@CTP2016]

Super B, Best tutorial. Thanks

[@PowerExbyJitendra]

Glad it was helpful!

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

[@aravindkarthik6094]

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

[@rohansen6744]

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

[@PowerExbyJitendra]

You are most welcome🙏

[@NaveedAhmad-HFD]

Very nice & informative

[@PowerExbyJitendra]

Thanks a lot

[@rushiamin1008]

Wonderful ❤

[@PowerExbyJitendra]

Thanks

[@pankajagrawal8546]

😮maza a gya yar

[@Rubelkhan-qx1tx]

Thank you so much nice work

[@PowerExbyJitendra]

Welcome

[@rajeshchoudhary2520]

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

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

[@Rajumaster]

Excellent topic.. Thank you

[@PowerExbyJitendra]

Welcome

[@Abhijitjitu]

Very good👍

[@PowerExbyJitendra]

Thanks

[@Mannabhav]

Big fan sir 🙏💐🙏

[@shankargaikwad1107]

USEFULL INFORMATION, Thanks

[@jeraldthalaiva85]

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

[@NaveedAhmad-HFD]

Thank you so much for sharing

[@ayush112811]

Super , needed exactly the same for my work

[@PowerExbyJitendra]

Thanks

[@indian35556]

Wonderful Sir

[@PowerExbyJitendra]

Thanks

[@sureshv7724]

Super baiya,

[@manjit.sarania]

Very important tricks

[@PowerExbyJitendra]

Thank you so much❤

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

[@umeshsharma1492]

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

[@dineshtak3363]

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

[@mdmukhlisurrahman9351]

Very nice Thanks

[@PowerExbyJitendra]

You are welcome

[@motivationt3al]

Thank you so much sir 🙏🙏

[@PowerExbyJitendra]

Welcome🙏

[@mohanjoshi5639]

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

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

[@nagendraprathap9697]

thanks for sharing your valuable knowledge

[@PowerExbyJitendra]

Thanks Nagendra ji

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

[@virendratiwari3614]

Very good sir

[@PowerExbyJitendra]

Thanks 🙏🙏🙏🙏

[@s.s1551]

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

[@PowerExbyJitendra]

Yes

[@wahidrashid4865]

Beautiful sir

[@PowerExbyJitendra]

Thanks 🙏

[@rajadey1552]

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

[@KundanFluteArt]

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

[@bhaskararaodv555]

Super...

[@PowerExbyJitendra]

Thanks

[@NaveedAhmad-HFD]

Tha k you so much

[@NaveedAhmad-HFD]

Superb

[@PowerExbyJitendra]

Thanks 🤗

[@nazmunnaharpriyamoni]

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

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

[@kavimangalsharma8539]

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

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

[@ArifulIslam-dr4bg]

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

[@kamalgupta4853]

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

[@DIVYANGMEDIAODIA]

Nice video

[@PowerExbyJitendra]

So nice

[@deepakarora7478]

Amazing

[@PowerExbyJitendra]

Thanks🙏

[@rajatkumaryadav9438]

Super sir

[@PowerExbyJitendra]

Thanks a lot

[@ashrafk.m.3936]

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

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

[@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:
th-cam.com/video/1lMzbCpSckU/w-d-xo.htmlsi=6CfneuAECfX_Ppgw

[@edix_zone850]

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

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

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

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

[@saltnpepper1122]

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

[@Amarjit82]

Excellent

[@PowerExbyJitendra]

Thanks

[@livegaming5958]

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

[@rajeshmakwana5515]

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

[@jethavachandrakant4864]

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

[@neilfernandas569]

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

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

[@markandeyagorantala2787]

Sir shall we get products wise details also in this?

[@jethavachandrakant4864]

Aage row jyada select kaise kare

[@sajadkhanmmd6634]

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

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

[@income_zone1]

Ye same entry Google sheet mei kaise kre?

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

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

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

[@animalsworld-mb5xd]

How to download those practice file sir

[@PowerExbyJitendra]

Downloading link is given in description box.

[@tasawarhussainshah7038]

How to create sheets

[@Pashto_song2025]

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

[@PowerExbyJitendra]

Ok

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

[@ammarhaider9881]

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

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

[@salmsnali786110]

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

[@bhanushali43]

FACING SOME PROBLEM IN EXCLE WORKSHEET AUTOMATIC DATA TRANSFER

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

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

[@arshad1781]

Nice

[@PowerExbyJitendra]

Thanks

[@jdroy7910]

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

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

[@razaali8230]

Bahijan 18 wali invoice nhe i qq

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

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

[@ashishyadav-gg9yl]

Can u place share this sheet

[@PowerExbyJitendra]

Downloading link is given in description box.