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.

[@thebesttechnical3608]

You are always so concise and professional

[@saeedyounis5884]

It was really helpful in my work. i just apply it. i am really grateful for your help. Thank You So Much

[@adityanursery2064]

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

[@imdadhussain5856]

Yahi Chahye tha! Thanks A Lot Sir

[@asma1311]

Subscribed and Liked it too ❤

[@kartickiyer]

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

[@yashwantbhalekar]

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

[@ParamOffshore]

Keep learning, and this vedio is good

[@techgalaxy100]

بہت ہی غمدہ۔

[@OmarEdits24]

thank you .... u r of great help

[@centinel_prime]

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

[@Shinewithsonu65]

Yahi chaah rha tha 😊😊😊😊 thank you sir 🎉

[@vishnugangadhar]

I have one doubt in our main sheet if any have changed intermediate RAWS also changes in our sub sheets

[@TariqKhan-gc3pe]

EXCELLENT! I am excited

[@sanjaykate7658]

Nice 🎉

[@musclepower1620]

Nice Bro... ❤❤

[@tiruveedipradeepkumar1487]

Very nice❤❤❤

[@amollaate4657]

Thanks bro looking for this type of information 😊😊😊

[@naeemhazara3568]

bhai apki video achi ha ..But agr yahi table k nechy ma dusri sheet ka sara data ksy insert krun matlb 2 sheet han table form ma ek sheet ma separate table ksy banana ha

[@PlanetRobo]

Use power query instead for live updations( In case if u want to reflect changes in master data to sub tables )

[@rizwanshaikh5469]

Good explanation

[@mdrakibulhasanmahmudcmamba5919]

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

[@surajkc7335]

got it but how to make data appear on the basis of date (sort oldest to newest) automatically from macro?

[@joragolds3146]

AMAZING🎉

[@wasilkhan-q9u]

Thank you , if we need to add more columns , so how to do it

[@sudhirvare9548]

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

[@somenmondal2964]

Nice and very Helpful

[@jkoresh5483]

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.

[@chandrakumarr1733]

Super veryful this video

[@tanvirashik3979]

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]

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]

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

[@musqatparts5915]

Very Nice

[@IrfanAnsari-c6o]

Nice info, thanks i

[@silviachavhan5723]

What if there are multiple client records available? Like more than 50 clients.

[@Crickethighligth360]

Great🎉

[@NaveedAhmad-HFD]

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]

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.

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

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

[@mehmoodali2521]

Ye temporary data entries ha ya save Karne k bad agle din bi es worksheet m a isi Tara Kam ho Sakta ha

[@MRBTechSolutions]

Permanent

[@mukul3865]

Kese hota h mene save karke band Kiya fir sheet me work nhi kr rha h kya kru sir

[@Historytimeline270]

Thanks bro ❤

[@sonucybercafe-c7f]

NICE SIR

[@cabijoscaria3763]

Thanks awesome video

[@mohammedkassimsalim9351]

Can i add columns in main sheet after making macro?

[@MRBTechSolutions]

No you can't

[@EAmalik1870]

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

[@MRBTechSolutions]

Filter function available in 365 only

[@naveenwanigasundara2206]

Thanks A Lot Sir

[@mirubaig1692]

Great

[@shahbazahmed9646]

hello in which type i should save file it was working perfectly as i save the file after that it was not working

[@MRBTechSolutions]

Save as Excel maceo enabled workbook

[@muhammadumer8473]

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

[@MRBTechSolutions]

Yes

[@NAITIKKAHANIKISSE]

Lekin ek prob he jab file save karate hen to Macro enabled file me save hota he jisase macro remove ho jata he
Isaka kya pay he ki data save karane ke baad fir se usi tarah chalata rahe file me macro

[@Sefimunsi]

Nice

[@muhammedanvermuhammedazeem5668]

Super

[@muhammadsaqib8869]

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

[@MRBTechSolutions]

No

[@Awais.younas]

Outstanding

[@talokermasti]

Good usefull

[@gopalregmi9075]

thanks sir 🙏🇳🇵🇳🇵

[@manojkumarsingh8024]

Save karne ke baad kya ye Google drive pe kaam karega

[@MRBTechSolutions]

Ni

[@aslamqureshi3894]

In which formate should i save all files?

[@MRBTechSolutions]

Micro enabled excel workbook

[@BDwings-kq2wc]

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]

Plz make sure you typed same name of macro in vba coding as you assigned name at the time of recording

[@BDwings-kq2wc]

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]

@@BDwings-kq2wc i said after starting macro recording avoid extra clicks. Never click any other cell after recording macro

[@braveheart4651]

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

[@souravmukherjee1992]

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

[@MuhammadKhan-zf3my]

السلام علیکم صحت بخیر: استاد محترم جب میں view code سے میکرو چالو کرتا ہوں آپ کے طریقے کے مطابق تو میکرو آ ٹو کام نہیں کرتا ۔آپ کی نوازش ہوگی اگر رہنمائی فرمائے۔
میں کراچی پاکستان سے ہوں اگر آپ محترم بھی کراچی سے ہے تو ایڈریس دیدیں تو خود خدمت میں حاضر ہوجاؤں ۔وعلیکم السلام

[@jaisheo3776]

Sir ek sheet me type karu or us naam se dusra sheet auto create ho kar usme data entry ho sakta hai kya

[@MRBTechSolutions]

Use pivot table and generate sheets

[@iqrazonecommerce6126]

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

[@Sunny_Act2003]

Agar another workbook mai transfer Krna ho to kya krenge

[@adilhassan987]

very good thanks

[@marutidalawayi1727]

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

[@DMHLêkolîn]

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]

At thet time, you will get "Stop Recording" ..you have to press to stop recording.

[@amalkchakma749]

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]

Please save file as macro enabled workbook

[@__-ql1cx]

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]

Need to record macro for every new customer

[@rpraveenkumar94]

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]

Plz watch my video automatic search box in excel

[@softskillsittraining]

Excellent 👌👍

[@shazilsonu43]

EXCELLENT Dear.

[@EAmalik1870]

Thanks brother

[@nagarajands8399]

thank u so much

[@mdmoqbool2716]

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

[@bhaktiras7116]

school fee aur bus fee dono ki sheet alag alag hai schoo aur bus fee ki total karana hai ek hi sheet me kese kare

[@Aarfana786]

Excellent

[@abdullahibrahim7972]

Hi need your help

[@manshakorjani257]

AGAR ISME PER COUSTOMER KE BICH ME TOTAL AVAILABLE HO THEN KESE SPLIT KARE

[@bhargavpanchal1350]

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?

[@gautamgaikwad1553]

Not working when adding another entry

[@itzsimple6591]

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

[@MRBTechSolutions]

Plz record macro again and follow all steps

[@samenspare9856]

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

[@theeducationist2901]

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

[@MRBTechSolutions]

If someone have not office 365 then?

[@MrShahed1985]

Thanks a lot brother. EXCELLENT! I am excited 😊

[@adityanursery2064]

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

[@md.mizanurrahman60]

excillent

[@HAKEEMG-in4ly]

سر تمام کام ٹھیک ہوتا ہے۔اسی فائل پر گھنٹوں کام کریں بالکل صحیح ہوتا ہے۔لیکن اگلے دن میکرو کام نہیں کرتا۔اور جس جگہ میکرو سیو کرتے ہیں وہاں میکرو جو سیو کیا ہوتا ہے نہیں ملتا۔میں کافی فائل بنا چکا ہوں ہر بار یہی مسئلہ ہوتا ہے۔

[@Yasir_Abbas_Tarar]

Ap file ko save as macro file kya krain

[@pawanmehla7140]

Sir date and time ekte aa raha to date alag karni h

[@MRBTechSolutions]

Change format

[@radtechshort]

How to use this function in google.sheet

[@gandeepmahi561]

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 .

[@qw123es]

Best

[@BalmukundSharma-n8t]

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

[@skdaveskdave9798]

Window 7 excel filter not find but filterxml how to insert filter

[@MRBTechSolutions]

I have not used filter function use advanced filter

[@trivenil2225]

Where is developer option in 2007 version

[@shivrudrachapule]

I NEED HELP

[@itsNaumanK]

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

[@9901028711]

If we have bulk data example 50 members how to write code

[@MohanKumar-wp8kc]

superb

[@deepaksingh-gk7ep]

Mera vba code kaam nhi kar plzz help

[@urvilshah7070]

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

[@MRBTechSolutions]

Just save as micro enabled and share it

[@BMAKanishkumar]

Bhai VBA code is not working for me. Why should we use call asif. What to use if I have male and female instead of asif and jamil

[@MRBTechSolutions]

Write name of macro you assigned unstead of asif

[@FakharAbbas-iq8gy]

Good job

[@mohammedkassimsalim9351]

Run time error 40056. Allication defined or obhext defines error