Automatic Transfer Data From Master Sheet to Another Sheets in Excel | MRB Tech Solutions

  Рет қаралды 540,651

MRB Tech Solutions

MRB Tech Solutions

Жыл бұрын

In This excel Tutorial you will learn how to transfer data automatically from master sheet to another sheet. Just enter data into master sheet the entries automatically transfer their related sheets.

Пікірлер: 169
@techgalaxy100
@techgalaxy100 13 күн бұрын
بہت ہی غمدہ۔
@imdadhussain5856
@imdadhussain5856 5 ай бұрын
Yahi Chahye tha! Thanks A Lot Sir
@saeedyounis5884
@saeedyounis5884 9 ай бұрын
It was really helpful in my work. i just apply it. i am really grateful for your help. Thank You So Much
@adityanursery2064
@adityanursery2064 5 ай бұрын
Not Benificial. if no of customer is 1000 then ???
@shazilsonu43
@shazilsonu43 10 ай бұрын
EXCELLENT Dear.
@amollaate4657
@amollaate4657 3 ай бұрын
Thanks bro looking for this type of information 😊😊😊
@softskillsittraining
@softskillsittraining 9 ай бұрын
Excellent 👌👍
@mdrakibulhasanmahmudcmamba5919
@mdrakibulhasanmahmudcmamba5919 7 ай бұрын
Thanks brother. Would pls tell me how it will be interactive even close current session.
@gowachak9353
@gowachak9353 10 ай бұрын
Excellent.
@centinel_prime
@centinel_prime 6 ай бұрын
great job. one query is what to when there are multiple sheets, and most importantly what happens when there is no entry in any sheet and want to print those sheets which contains data only? i mean how command automatic printing option only those pages which has data entered and blanks will be lefted
@MrShahed1985
@MrShahed1985 10 ай бұрын
Thanks a lot brother. EXCELLENT! I am excited 😊
@adityanursery2064
@adityanursery2064 5 ай бұрын
Not Benificial. if no of customer is 1000 then ???
@cabijoscaria3763
@cabijoscaria3763 6 ай бұрын
Thanks awesome video
@chandrakumarr1733
@chandrakumarr1733 7 ай бұрын
Super veryful this video
@braveheart4651
@braveheart4651 10 ай бұрын
kindly provide the worksheet and practice materials in the description on your videos.
@mdibrahimshikder9263
@mdibrahimshikder9263 8 ай бұрын
jazakallaha sir.
@Aarfana786
@Aarfana786 8 ай бұрын
Excellent
@FakharAbbas-iq8gy
@FakharAbbas-iq8gy Жыл бұрын
Good job
@mdnasarullah4549
@mdnasarullah4549 8 ай бұрын
Thanks sir! ❤
@AbdullahTech700
@AbdullahTech700 10 ай бұрын
Nice 💯
@MohanKumar-wp8kc
@MohanKumar-wp8kc 9 ай бұрын
superb
@Awais.younas
@Awais.younas 6 ай бұрын
Outstanding
@jkoresh5483
@jkoresh5483 4 ай бұрын
Hello Dear, I have COT data and wanted to know if you can help me do the updates to fetch the data automatically it from a website and also to shift the data to Google Sheets as well. Planning to do the updates manually later but for now I have the subscription till the end of the year with MS65. Thank you.
@adilhassan987
@adilhassan987 17 күн бұрын
very good thanks
@mirubaig1692
@mirubaig1692 6 ай бұрын
Great
@joragolds3146
@joragolds3146 3 ай бұрын
AMAZING🎉
@musclepower1620
@musclepower1620 4 ай бұрын
Nice Bro... ❤❤
@TariqKhan-gc3pe
@TariqKhan-gc3pe 5 ай бұрын
EXCELLENT! I am excited
@Crickethighligth360
@Crickethighligth360 5 ай бұрын
Great🎉
@AnkitVerma-cv7rp
@AnkitVerma-cv7rp 14 күн бұрын
Thank you sir.
@yashwantbhalekar
@yashwantbhalekar 5 ай бұрын
Bahot badhiya bhai. Kya yeh across worbooks bhi itna hi achhe se chalega ? kya problems aa sakti hai ?😇
@kartikiyerr
@kartikiyerr 3 ай бұрын
Thank you for this video! For me new lines are not updating automatically... Where i am doing mistake?
@talokermasti
@talokermasti 22 күн бұрын
Good usefull
@tiruveedipradeepkumar1487
@tiruveedipradeepkumar1487 5 ай бұрын
Very nice❤❤❤
@user-ij8lr3xo2v
@user-ij8lr3xo2v 5 ай бұрын
Very nice
@user-vz6yd5fj1g
@user-vz6yd5fj1g 7 ай бұрын
NICE SIR
@musqatparts5915
@musqatparts5915 5 ай бұрын
Very Nice
@rizwanabbas1422
@rizwanabbas1422 Жыл бұрын
good
@EAmalik1870
@EAmalik1870 4 ай бұрын
Thanks brother
@samenspare9856
@samenspare9856 10 ай бұрын
Hi can you help pls this data entry show me by Google sheet .
@Sefimunsi
@Sefimunsi 4 ай бұрын
Nice
@jayatendulkar
@jayatendulkar 9 ай бұрын
I am not able to find - Data - Advanced in google sheet. Can someone help me with recording macro's in google sheet?
@MustjabsEditing
@MustjabsEditing 10 ай бұрын
Superb ❤ 1 question If we delet any data from main sheet. 1. If we delet from main sheet It should not delet from sub sheets & should save data in sub sheets What we should do for these results. Does not deleta data from sub sheets Asif & Jameel
@saeedyounis5884
@saeedyounis5884 9 ай бұрын
Sir your main sheet is data sheet... if you amend it or delete it, of course it will be deleted in other sheets too. i checked.
@ImranKhan-il9me
@ImranKhan-il9me Жыл бұрын
Exactly like this I have to transfer data from more than one sheet on basis of criteria
@adityanursery2064
@adityanursery2064 5 ай бұрын
Not Benificial. if no of customer is 1000 then ???
@marutidalawayi1727
@marutidalawayi1727 3 ай бұрын
Please tell me 100000 thousand above + and 100000 below have to come what formol this in exel
@tanvirashik3979
@tanvirashik3979 7 ай бұрын
At first, thanks for this awesome tutorial video. I have a question. In 6:22 minute, you write "call asif" to activate the full worksheet. My question is here how writing "asif" connecting the asif book shop tab? I mean what will be the calling name or parameter for our own tab. For example, if I create a tab "Intermediate result list" tab, what will be the name/parameter to write instead of "call asif".
@MRBTechSolutions
@MRBTechSolutions 7 ай бұрын
I named macro name asif for asif worksheet. You can assign any name for worksheet just remember the macro name and worksheet for which macro is recorded. For example you have worksheet intermediate you can assign macro name intermediate or any one.
@tanvirashik3979
@tanvirashik3979 7 ай бұрын
@@MRBTechSolutions Understand. Can you tell me how can I make a excel file where one tab will be excel data and in another tab the 1st tab data will auto converted to xml data format. Any recommended video or searching video title will be helpful.
@iqrazonecommerce6126
@iqrazonecommerce6126 6 ай бұрын
How to write the details in A1 column in Excel without copy pasting in B1 cell.
@itzsimple6591
@itzsimple6591 20 сағат бұрын
thanks you. i am showed an error run time error 1004 can you help to solve it???
@md.mizanurrahman60
@md.mizanurrahman60 4 ай бұрын
excillent
@theeducationist2901
@theeducationist2901 7 ай бұрын
Simply use filter formula with condition.then use data validation in for customer list
@MRBTechSolutions
@MRBTechSolutions 7 ай бұрын
If someone have not office 365 then?
@qw123es
@qw123es 7 ай бұрын
Best
@najeebullah5065
@najeebullah5065 8 ай бұрын
@bhargavpanchal1350
@bhargavpanchal1350 6 ай бұрын
Agare two row header ho us me first vali row me kuch column second wali cell se merge ho tao two row ko header ho tao ye kese hoga? Kiyu ki Single header hoga tao hota hai lekin header me agre two row lekar kre na ho tao?
@muhammadsaqib8869
@muhammadsaqib8869 Жыл бұрын
Thank you, i want to delete record from master sheet after transfer the data, is it possible sir
@MRBTechSolutions
@MRBTechSolutions 11 ай бұрын
No
@user-ol6jo2cq5d
@user-ol6jo2cq5d 8 ай бұрын
GOOD VIDEO BUT I AM NOT GETTING VIEW CODE IN OFFICE 2013
@urvilshah7070
@urvilshah7070 Жыл бұрын
How should I save the File Type as to share it on WhatsApp with the Coding & Macros enabled intact?
@MRBTechSolutions
@MRBTechSolutions 11 ай бұрын
Just save as micro enabled and share it
@user-xo3yh6uf2z
@user-xo3yh6uf2z 5 ай бұрын
My dear brother, I have implemented your method to the letter, but when you run the macro, it empties the entire table, including the equations as well. I have a question: Between time 4.36 and 4.42, do you mean that we stop recording the macro or what exactly? Please explain the reason for this problem.
@MdFahim-uf1bj
@MdFahim-uf1bj 5 ай бұрын
At thet time, you will get "Stop Recording" ..you have to press to stop recording.
@GajananFunde
@GajananFunde 10 ай бұрын
Automatic data transfer for Google sheet?
@thapasantosh2288
@thapasantosh2288 Ай бұрын
Thank you for the video. I just face one problem, While transferring data to individual sheet and creating table with header face problem of debugging and failed to transfer data. Could you please help me to solve this?
@MRBTechSolutions
@MRBTechSolutions Ай бұрын
Headers should b same on both sheets. If there is extra space in headers you may face problem
@EAmalik1870
@EAmalik1870 4 ай бұрын
Sir the new filter features in excel 2019 =filter( work in same without recording micro
@MRBTechSolutions
@MRBTechSolutions 4 ай бұрын
Filter function available in 365 only
@hearram
@hearram 10 ай бұрын
Thanks for this excellent video. I also wanted to ask you another query. is it possible i could email you and you would be able to reply.
@mdmoqbool2716
@mdmoqbool2716 5 ай бұрын
Bhai i am trying to do but not i am showing invalid outside procedure
@FakharAbbas-iq8gy
@FakharAbbas-iq8gy Жыл бұрын
Hello sir I wAnt Ur help plz
@gandeepmahi561
@gandeepmahi561 3 ай бұрын
Hlo sir, mere Excel sheet main cash aur UPI ki sale different different rows main oper nehce hoti hai,main cash sale ko ourer ki 10 rows main sift karna chthta houn aur UPI ko neche ki 10 rows ko , please koi trick batao mujhe har bar copy past karna padta hai .
@abdullahibrahim7972
@abdullahibrahim7972 6 ай бұрын
Hi need your help
@shahbazahmed9646
@shahbazahmed9646 6 ай бұрын
hello in which type i should save file it was working perfectly as i save the file after that it was not working
@MRBTechSolutions
@MRBTechSolutions 6 ай бұрын
Save as Excel maceo enabled workbook
@thehgamers
@thehgamers 10 ай бұрын
I get this error when I open page after doing similar work . After doing everything when I open sheet, it’s says Compile error Sub or function not defined
@MRBTechSolutions
@MRBTechSolutions 10 ай бұрын
Pls follow all steps correctly
@muhammadumer8473
@muhammadumer8473 7 ай бұрын
what if we delete any entry in the sales Book will be it deleted from other sheets as well?
@MRBTechSolutions
@MRBTechSolutions 7 ай бұрын
Yes
@gautamgaikwad1553
@gautamgaikwad1553 5 ай бұрын
Not working when adding another entry
@miyasaheb1611
@miyasaheb1611 9 ай бұрын
Good morning sir Mane Keya tho alage alage customer report me nahi aaraha hai sir pls isa keli explain Karo sir
@retr.onostalgic
@retr.onostalgic 4 ай бұрын
how this type work in google sheet
@amalkchakma749
@amalkchakma749 6 ай бұрын
I have seen you full videos and accordingly i had practice fully. However, when i open the same file the data is not automatic transfer from master sheets to Asif Book Shop or Jamil Book Shop. I have tried to re-activated but not working.
@MRBTechSolutions
@MRBTechSolutions 6 ай бұрын
Please save file as macro enabled workbook
@rpraveenkumar94
@rpraveenkumar94 8 ай бұрын
I have a excel sheet database. I want to extract 5 to 6 data by entering one unique data in a cell. How to do that?
@MRBTechSolutions
@MRBTechSolutions 7 ай бұрын
Plz watch my video automatic search box in excel
@mohammedkassimsalim9351
@mohammedkassimsalim9351 4 ай бұрын
Can i add columns in main sheet after making macro?
@MRBTechSolutions
@MRBTechSolutions 4 ай бұрын
No you can't
@__-ql1cx
@__-ql1cx 7 ай бұрын
After finished all preperation, when we need to add another name or sheets. then how it will..? i mean out of asif and jamil
@MRBTechSolutions
@MRBTechSolutions 7 ай бұрын
Need to record macro for every new customer
@mohammedkassimsalim9351
@mohammedkassimsalim9351 4 ай бұрын
Run time error 40056. Allication defined or obhext defines error
@jaisheo3776
@jaisheo3776 10 ай бұрын
Sir ek sheet me type karu or us naam se dusra sheet auto create ho kar usme data entry ho sakta hai kya
@MRBTechSolutions
@MRBTechSolutions 7 ай бұрын
Use pivot table and generate sheets
@trivenil2225
@trivenil2225 4 ай бұрын
Where is developer option in 2007 version
@aslamqureshi3894
@aslamqureshi3894 4 ай бұрын
In which formate should i save all files?
@MRBTechSolutions
@MRBTechSolutions 4 ай бұрын
Micro enabled excel workbook
@BDwings-kq2wc
@BDwings-kq2wc 8 ай бұрын
Recording Macro next step as you done same here I was did it.But data Doesn't appear on selected person. please help.Thanks for this vedio
@MRBTechSolutions
@MRBTechSolutions 8 ай бұрын
Plz make sure you typed same name of macro in vba coding as you assigned name at the time of recording
@BDwings-kq2wc
@BDwings-kq2wc 8 ай бұрын
when you created macro of asif than you say something. which I can't understand.Than after you click the data tab.this part I can't understand
@MRBTechSolutions
@MRBTechSolutions 8 ай бұрын
@@BDwings-kq2wc i said after starting macro recording avoid extra clicks. Never click any other cell after recording macro
@souravmukherjee1992
@souravmukherjee1992 4 ай бұрын
Isko agar reverse karna hai to kya karna padega...??
@skdaveskdave9798
@skdaveskdave9798 3 ай бұрын
Window 7 excel filter not find but filterxml how to insert filter
@MRBTechSolutions
@MRBTechSolutions 3 ай бұрын
I have not used filter function use advanced filter
@MuhammadKhan-zf3my
@MuhammadKhan-zf3my Жыл бұрын
السلام علیکم صحت بخیر: استاد محترم جب میں view code سے میکرو چالو کرتا ہوں آپ کے طریقے کے مطابق تو میکرو آ ٹو کام نہیں کرتا ۔آپ کی نوازش ہوگی اگر رہنمائی فرمائے۔ میں کراچی پاکستان سے ہوں اگر آپ محترم بھی کراچی سے ہے تو ایڈریس دیدیں تو خود خدمت میں حاضر ہوجاؤں ۔وعلیکم السلام
@ngshadowff73
@ngshadowff73 9 ай бұрын
Sir isse acha index use krlo
@creativesongs5211
@creativesongs5211 3 ай бұрын
I do every step to step like you ...its not work please help me sir
@HAKEEMG-in4ly
@HAKEEMG-in4ly 4 ай бұрын
سر تمام کام ٹھیک ہوتا ہے۔اسی فائل پر گھنٹوں کام کریں بالکل صحیح ہوتا ہے۔لیکن اگلے دن میکرو کام نہیں کرتا۔اور جس جگہ میکرو سیو کرتے ہیں وہاں میکرو جو سیو کیا ہوتا ہے نہیں ملتا۔میں کافی فائل بنا چکا ہوں ہر بار یہی مسئلہ ہوتا ہے۔
@IrfanAli-hq8pm
@IrfanAli-hq8pm 8 ай бұрын
Assalam o Alaikum Bhai g mujay koi asi excel sheet btyo jis ma work kro our wo two sheet ma khud hi garnett hu jaya
@MRBTechSolutions
@MRBTechSolutions 7 ай бұрын
Plz watch on challen link excel worksheet
@ThalankiMithun-ro2ch
@ThalankiMithun-ro2ch 8 ай бұрын
If we have 100 customers then how to do pls explain sir..?
@MRBTechSolutions
@MRBTechSolutions 7 ай бұрын
Plz watch my another video transfer data with pivot table
@md.porosmolla248
@md.porosmolla248 11 ай бұрын
How to close the code window?? my code is not working?
@ARHAM559
@ARHAM559 10 ай бұрын
Yeah same problem here
@SaifKhan-xz1jh
@SaifKhan-xz1jh 5 ай бұрын
@@ARHAM559 same
@lakhanbhavyansh
@lakhanbhavyansh Жыл бұрын
Hello sir apki help chahiye
@MRBTechSolutions
@MRBTechSolutions Жыл бұрын
Yes
@lakhanbhavyansh
@lakhanbhavyansh Жыл бұрын
Apka contact number milega
@dayanandsambaragimath4316
@dayanandsambaragimath4316 8 ай бұрын
Apka baati bahot ho gaya .
@9901028711
@9901028711 10 ай бұрын
If we have bulk data example 50 members how to write code
@user-dp5bv9qw4j
@user-dp5bv9qw4j Жыл бұрын
AP KN SA EXCAL USE KR RHY H IS CLASS MN
@MRBTechSolutions
@MRBTechSolutions Жыл бұрын
2018
@manojkumarsingh8024
@manojkumarsingh8024 9 ай бұрын
Save karne ke baad kya ye Google drive pe kaam karega
@MRBTechSolutions
@MRBTechSolutions 7 ай бұрын
Ni
@somenathbagchi6215
@somenathbagchi6215 5 ай бұрын
How I write actual name in view code Call asif Please help me
@MRBTechSolutions
@MRBTechSolutions 5 ай бұрын
Write your macro name where i write asif
@jitendrakumarrout8028
@jitendrakumarrout8028 10 ай бұрын
If i have 1000 nos.of sales person then how many time i will follow the step ?
@MRBTechSolutions
@MRBTechSolutions 10 ай бұрын
You cane check me another data transfer video
@ThalankiMithun-ro2ch
@ThalankiMithun-ro2ch 8 ай бұрын
Pls pin the link
@theeducationist2901
@theeducationist2901 7 ай бұрын
use filter formula simply.
@Butterflylusifer
@Butterflylusifer 3 ай бұрын
I have a problem... Can you solve this problem sir . Save karne ke baad code work ni kar ra hai
@MRBTechSolutions
@MRBTechSolutions 3 ай бұрын
Save file as macro enabled excel file
@abrarhussain1164
@abrarhussain1164 10 ай бұрын
I have one master sheet and other 3 sheets. Transferred data successfully on one sheet but no data is shown on other two sheets. Kindly tell where is the mistake
@MRBTechSolutions
@MRBTechSolutions 10 ай бұрын
Please use same method for 3 times if you have 3 worksheets.
@electricus_aniruddhachanda8184
@electricus_aniruddhachanda8184 7 ай бұрын
Sorry ,vai sahab ap orr jari si dhime bat kare to sayed samajh ne may sahuliyat hota. Accha plz ab batay ki 2nd sheet pe jane ka pahele hame kaya karne hoga ?? Bo thik se samajh nehi ayaa. Thnx
@lakhanbhavyansh
@lakhanbhavyansh Жыл бұрын
Apka kuch puchna hai
@MRBTechSolutions
@MRBTechSolutions Жыл бұрын
Yes
@lakhanbhavyansh
@lakhanbhavyansh Жыл бұрын
@@MRBTechSolutions apka contact number mil sakta hai kya
@pawanmehla7140
@pawanmehla7140 28 күн бұрын
Sir date and time ekte aa raha to date alag karni h
@MRBTechSolutions
@MRBTechSolutions 25 күн бұрын
Change format
@mehmoodali2521
@mehmoodali2521 3 ай бұрын
Save Karne k bad dobara ye table es Tara Kam nai karta ha
@MRBTechSolutions
@MRBTechSolutions 3 ай бұрын
Save file as macro enablee workbook
Consolidation in Excel (Hindi) | How to Consolidate Data in Excel
6:32
PowerEx by Jitendra
Рет қаралды 306 М.
How to Pull Data from Another Sheet based on Criteria in Excel & Google Sheets?
8:27
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 903 М.
I wish I could change THIS fast! 🤣
00:33
America's Got Talent
Рет қаралды 111 МЛН
Must-have gadget for every toilet! 🤩 #gadget
00:27
GiGaZoom
Рет қаралды 12 МЛН
Khó thế mà cũng làm được || How did the police do that? #shorts
01:00
THEY made a RAINBOW M&M 🤩😳 LeoNata family #shorts
00:49
LeoNata Family
Рет қаралды 28 МЛН
I bought new Creator/ Gaming laptop 😍
17:35
N K RAUT Vlogs
Рет қаралды 657
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 355 М.
AWESOME Excel trick to combine data from multiple sheets
7:27
Automatic Data Transfer From One Sheet To Another in Excel
6:12
MRB Tech Solutions
Рет қаралды 35 М.
7 Ways to Use Vlookup in Excel
16:44
My E-Lesson
Рет қаралды 2,7 МЛН
How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX
15:54
Tuts+ Computer Skills
Рет қаралды 5 МЛН
Transfer Data Customer Wise from One Sheet to multiple sheets in excel (Hindi)
21:01