Automatic Transfer Data From Master Sheet to Another Sheets in Excel | 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.

Пікірлер: 173

  • @techgalaxy100
    @techgalaxy10021 күн бұрын

    بہت ہی غمدہ۔

  • @imdadhussain5856
    @imdadhussain58565 ай бұрын

    Yahi Chahye tha! Thanks A Lot Sir

  • @sudhirvare9548
    @sudhirvare95487 күн бұрын

    Thank you So much!!! This is really excellent!

  • @amollaate4657
    @amollaate46573 ай бұрын

    Thanks bro looking for this type of information 😊😊😊

  • @shazilsonu43
    @shazilsonu4311 ай бұрын

    EXCELLENT Dear.

  • @mdnasarullah4549
    @mdnasarullah45499 ай бұрын

    Thanks sir! ❤

  • @saeedyounis5884
    @saeedyounis58849 ай бұрын

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

  • @cabijoscaria3763
    @cabijoscaria37636 ай бұрын

    Thanks awesome video

  • @TariqKhan-gc3pe
    @TariqKhan-gc3pe5 ай бұрын

    EXCELLENT! I am excited

  • @gowachak9353
    @gowachak935311 ай бұрын

    Excellent.

  • @softskillsittraining
    @softskillsittraining9 ай бұрын

    Excellent 👌👍

  • @chandrakumarr1733
    @chandrakumarr17337 ай бұрын

    Super veryful this video

  • @mdibrahimshikder9263
    @mdibrahimshikder92638 ай бұрын

    jazakallaha sir.

  • @MrShahed1985
    @MrShahed198511 ай бұрын

    Thanks a lot brother. EXCELLENT! I am excited 😊

  • @adityanursery2064

    @adityanursery2064

    5 ай бұрын

    Not Benificial. if no of customer is 1000 then ???

  • @AnkitVerma-cv7rp
    @AnkitVerma-cv7rp21 күн бұрын

    Thank you sir.

  • @joragolds3146
    @joragolds31463 ай бұрын

    AMAZING🎉

  • @AbdullahTech700
    @AbdullahTech70010 ай бұрын

    Nice 💯

  • @EAmalik1870
    @EAmalik18704 ай бұрын

    Thanks brother

  • @adilhassan987
    @adilhassan98724 күн бұрын

    very good thanks

  • @tiruveedipradeepkumar1487
    @tiruveedipradeepkumar14875 ай бұрын

    Very nice❤❤❤

  • @Aarfana786
    @Aarfana7869 ай бұрын

    Excellent

  • @FakharAbbas-iq8gy
    @FakharAbbas-iq8gy Жыл бұрын

    Good job

  • @Crickethighligth360
    @Crickethighligth3605 ай бұрын

    Great🎉

  • @musclepower1620
    @musclepower16204 ай бұрын

    Nice Bro... ❤❤

  • @mdrakibulhasanmahmudcmamba5919
    @mdrakibulhasanmahmudcmamba59197 ай бұрын

    Thanks brother. Would pls tell me how it will be interactive even close current session.

  • @mirubaig1692
    @mirubaig16926 ай бұрын

    Great

  • @Awais.younas
    @Awais.younas7 ай бұрын

    Outstanding

  • @MohanKumar-wp8kc
    @MohanKumar-wp8kc10 ай бұрын

    superb

  • @talokermasti
    @talokermastiАй бұрын

    Good usefull

  • @user-vz6yd5fj1g
    @user-vz6yd5fj1g7 ай бұрын

    NICE SIR

  • @user-ij8lr3xo2v
    @user-ij8lr3xo2v5 ай бұрын

    Very nice

  • @musqatparts5915
    @musqatparts59156 ай бұрын

    Very Nice

  • @rizwanabbas1422
    @rizwanabbas1422 Жыл бұрын

    good

  • @md.mizanurrahman60
    @md.mizanurrahman605 ай бұрын

    excillent

  • @centinel_prime
    @centinel_prime6 ай бұрын

    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

  • @braveheart4651
    @braveheart465110 ай бұрын

    kindly provide the worksheet and practice materials in the description on your videos.

  • @Sefimunsi
    @Sefimunsi4 ай бұрын

    Nice

  • @qw123es
    @qw123es8 ай бұрын

    Best

  • @yashwantbhalekar
    @yashwantbhalekar5 ай бұрын

    Bahot badhiya bhai. Kya yeh across worbooks bhi itna hi achhe se chalega ? kya problems aa sakti hai ?😇

  • @najeebullah5065
    @najeebullah50659 ай бұрын

  • @jkoresh5483
    @jkoresh54835 ай бұрын

    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.

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

  • @kartikiyerr
    @kartikiyerr3 ай бұрын

    Thank you for this video! For me new lines are not updating automatically... Where i am doing mistake?

  • @samenspare9856
    @samenspare985610 ай бұрын

    Hi can you help pls this data entry show me by Google sheet .

  • @tanvirashik3979
    @tanvirashik39797 ай бұрын

    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.

  • @theeducationist2901
    @theeducationist29017 ай бұрын

    Simply use filter formula with condition.then use data validation in for customer list

  • @MRBTechSolutions

    @MRBTechSolutions

    7 ай бұрын

    If someone have not office 365 then?

  • @MustjabsEditing
    @MustjabsEditing10 ай бұрын

    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.

  • @user-ol6jo2cq5d
    @user-ol6jo2cq5d8 ай бұрын

    GOOD VIDEO BUT I AM NOT GETTING VIEW CODE IN OFFICE 2013

  • @iqrazonecommerce6126
    @iqrazonecommerce61266 ай бұрын

    How to write the details in A1 column in Excel without copy pasting in B1 cell.

  • @jayatendulkar
    @jayatendulkar9 ай бұрын

    I am not able to find - Data - Advanced in google sheet. Can someone help me with recording macro's in google sheet?

  • @marutidalawayi1727
    @marutidalawayi17273 ай бұрын

    Please tell me 100000 thousand above + and 100000 below have to come what formol this in exel

  • @muhammadsaqib8869
    @muhammadsaqib8869 Жыл бұрын

    Thank you, i want to delete record from master sheet after transfer the data, is it possible sir

  • @MRBTechSolutions

    @MRBTechSolutions

    Жыл бұрын

    No

  • @gautamgaikwad1553
    @gautamgaikwad15535 ай бұрын

    Not working when adding another entry

  • @urvilshah7070
    @urvilshah7070 Жыл бұрын

    How should I save the File Type as to share it on WhatsApp with the Coding & Macros enabled intact?

  • @MRBTechSolutions

    @MRBTechSolutions

    Жыл бұрын

    Just save as micro enabled and share it

  • @dayanandsambaragimath4316
    @dayanandsambaragimath43168 ай бұрын

    Apka baati bahot ho gaya .

  • @bhargavpanchal1350
    @bhargavpanchal13506 ай бұрын

    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?

  • @GajananFunde
    @GajananFunde10 ай бұрын

    Automatic data transfer for Google sheet?

  • @itsNaumanK
    @itsNaumanKКүн бұрын

    Filter function use kro aur macro ki bhi zrurt nahi pare gi

  • @EAmalik1870
    @EAmalik18704 ай бұрын

    Sir the new filter features in excel 2019 =filter( work in same without recording micro

  • @MRBTechSolutions

    @MRBTechSolutions

    4 ай бұрын

    Filter function available in 365 only

  • @abdullahibrahim7972
    @abdullahibrahim79727 ай бұрын

    Hi need your help

  • @FakharAbbas-iq8gy
    @FakharAbbas-iq8gy Жыл бұрын

    Hello sir I wAnt Ur help plz

  • @user-xo3yh6uf2z
    @user-xo3yh6uf2z6 ай бұрын

    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.

  • @muhammadumer8473
    @muhammadumer84737 ай бұрын

    what if we delete any entry in the sales Book will be it deleted from other sheets as well?

  • @MRBTechSolutions

    @MRBTechSolutions

    7 ай бұрын

    Yes

  • @shahbazahmed9646
    @shahbazahmed96467 ай бұрын

    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

    7 ай бұрын

    Save as Excel maceo enabled workbook

  • @Sunny_Act2003
    @Sunny_Act20037 күн бұрын

    Agar another workbook mai transfer Krna ho to kya krenge

  • @miyasaheb1611
    @miyasaheb16119 ай бұрын

    Good morning sir Mane Keya tho alage alage customer report me nahi aaraha hai sir pls isa keli explain Karo sir

  • @gandeepmahi561
    @gandeepmahi5613 ай бұрын

    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 .

  • @retr.onostalgic
    @retr.onostalgic5 ай бұрын

    how this type work in google sheet

  • @jaisheo3776
    @jaisheo377610 ай бұрын

    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

    8 ай бұрын

    Use pivot table and generate sheets

  • @rpraveenkumar94
    @rpraveenkumar948 ай бұрын

    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

    8 ай бұрын

    Plz watch my video automatic search box in excel

  • @amalkchakma749
    @amalkchakma7496 ай бұрын

    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

  • @mdmoqbool2716
    @mdmoqbool27165 ай бұрын

    Bhai i am trying to do but not i am showing invalid outside procedure

  • @mohammedkassimsalim9351
    @mohammedkassimsalim93514 ай бұрын

    Can i add columns in main sheet after making macro?

  • @MRBTechSolutions

    @MRBTechSolutions

    4 ай бұрын

    No you can't

  • @thehgamers
    @thehgamers10 ай бұрын

    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

  • @thapasantosh2288
    @thapasantosh22882 ай бұрын

    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

    2 ай бұрын

    Headers should b same on both sheets. If there is extra space in headers you may face problem

  • @__-ql1cx
    @__-ql1cx7 ай бұрын

    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

  • @ngshadowff73
    @ngshadowff739 ай бұрын

    Sir isse acha index use krlo

  • @BDwings-kq2wc
    @BDwings-kq2wc8 ай бұрын

    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

  • @Khunryijduy
    @Khunryijduy10 ай бұрын

    Popcom 🎉❤❤❤❤❤❤❤❤❤🎉😊❤😊😊😊🎉😂😂😂🎉

  • @mohammedkassimsalim9351
    @mohammedkassimsalim93514 ай бұрын

    Run time error 40056. Allication defined or obhext defines error

  • @itzsimple6591
    @itzsimple65918 күн бұрын

    thanks you. i am showed an error run time error 1004 can you help to solve it???

  • @MRBTechSolutions

    @MRBTechSolutions

    7 күн бұрын

    Plz record macro again and follow all steps

  • @souravmukherjee1992
    @souravmukherjee19925 ай бұрын

    Isko agar reverse karna hai to kya karna padega...??

  • @lakhanbhavyansh
    @lakhanbhavyansh Жыл бұрын

    Hello sir apki help chahiye

  • @MRBTechSolutions

    @MRBTechSolutions

    Жыл бұрын

    Yes

  • @lakhanbhavyansh

    @lakhanbhavyansh

    Жыл бұрын

    Apka contact number milega

  • @hearram
    @hearram10 ай бұрын

    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.

  • @trivenil2225
    @trivenil22254 ай бұрын

    Where is developer option in 2007 version

  • @creativesongs5211
    @creativesongs52113 ай бұрын

    I do every step to step like you ...its not work please help me sir

  • @skdaveskdave9798
    @skdaveskdave97983 ай бұрын

    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 سے میکرو چالو کرتا ہوں آپ کے طریقے کے مطابق تو میکرو آ ٹو کام نہیں کرتا ۔آپ کی نوازش ہوگی اگر رہنمائی فرمائے۔ میں کراچی پاکستان سے ہوں اگر آپ محترم بھی کراچی سے ہے تو ایڈریس دیدیں تو خود خدمت میں حاضر ہوجاؤں ۔وعلیکم السلام

  • @aslamqureshi3894
    @aslamqureshi38945 ай бұрын

    In which formate should i save all files?

  • @MRBTechSolutions

    @MRBTechSolutions

    5 ай бұрын

    Micro enabled excel workbook

  • @electricus_aniruddhachanda8184
    @electricus_aniruddhachanda81847 ай бұрын

    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

  • @user-dp5bv9qw4j
    @user-dp5bv9qw4j Жыл бұрын

    AP KN SA EXCAL USE KR RHY H IS CLASS MN

  • @MRBTechSolutions

    @MRBTechSolutions

    Жыл бұрын

    2018

  • @lakhanbhavyansh
    @lakhanbhavyansh Жыл бұрын

    Apka kuch puchna hai

  • @MRBTechSolutions

    @MRBTechSolutions

    Жыл бұрын

    Yes

  • @lakhanbhavyansh

    @lakhanbhavyansh

    Жыл бұрын

    @@MRBTechSolutions apka contact number mil sakta hai kya

  • @MD.HasanAli-to2xh
    @MD.HasanAli-to2xh9 ай бұрын

    ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ

  • @IrfanAli-hq8pm
    @IrfanAli-hq8pm9 ай бұрын

    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

    8 ай бұрын

    Plz watch on challen link excel worksheet

  • @ThalankiMithun-ro2ch
    @ThalankiMithun-ro2ch8 ай бұрын

    If we have 100 customers then how to do pls explain sir..?

  • @MRBTechSolutions

    @MRBTechSolutions

    8 ай бұрын

    Plz watch my another video transfer data with pivot table

  • @md.porosmolla248
    @md.porosmolla24811 ай бұрын

    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

  • @AnjaliChauhanMViewshoursago
    @AnjaliChauhanMViewshoursago10 ай бұрын

    Isko advance filter bolte hai

  • @rajakabhilasha

    @rajakabhilasha

    7 ай бұрын

    Isko khud hi nhi pta kya btaa rha h 😂

  • @manojkumarsingh8024
    @manojkumarsingh80249 ай бұрын

    Save karne ke baad kya ye Google drive pe kaam karega

  • @MRBTechSolutions

    @MRBTechSolutions

    8 ай бұрын

    Ni

  • @somenathbagchi6215
    @somenathbagchi62156 ай бұрын

    How I write actual name in view code Call asif Please help me

  • @MRBTechSolutions

    @MRBTechSolutions

    6 ай бұрын

    Write your macro name where i write asif

  • @religarabkb828
    @religarabkb8286 ай бұрын

    आपका बतलाने का सैली ठीक है, पर प्रेक्टिकल कर के जो दिखाते है ,वो कान्हा तक ठीक है, वो तो दिखता ही नहीं है

Келесі