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

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

If both tables are in one sheet then what is the function? "Private Sub Worksheet_Activate() Call Asif Call Jamil End Sub"

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

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.

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

Can we use this method to my five hundred customers?

Not working when adding another entry

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

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

How to use this function in google.sheet

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?

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 .

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

Dada tomar help lagbe tomar number

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

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

Run time error 40056. Allication defined or obhext defines error

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

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

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

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

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

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

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

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

Mera vba code kaam nhi kar plzz help

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

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

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

Yahi Chahye tha! Thanks A Lot Sir

ERR MSG THIS COMMAND WILL STOP THE DEBUUGGER

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.

Thanks A Lot Sir

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?

Apka baati bahot ho gaya .

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?

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

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

Thanks bro ❤

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

Where is developer option in 2007 version

Agar another workbook mai transfer Krna ho to kya krenge

I NEED HELP

Isko advance filter bolte hai

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

Very good

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

Great

I have a problem... Can you solve this problem sir . Save karne ke baad code work ni kar ra hai

NICE SIR

After finished all preperation, when we need to add another name or sheets. then how it will..? i mean out of asif and jamil

how this type work in google sheet

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

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

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

Nice and very Helpful

Nice info, thanks i

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

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

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

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

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

Good usefull

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

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

بہت ہی غمدہ۔

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

Hi need your help

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

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

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

Thank you sir.

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

excillent

AP KN SA EXCAL USE KR RHY H IS CLASS MN

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

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

very good thanks

Can i add columns in main sheet after making macro?

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.

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

In which formate should i save all files?

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

Sir isse acha index use krlo

Thanks brother

Super

Nice

Nice

i have been doing prictice fro 6 days of behind but failed. what is the drama?

good

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

Nice 🎉

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

Automatic data transfer for Google sheet?

Hello sir I wAnt Ur help plz

Save Karne k bad dobara ye table es Tara Kam nai karta ha

ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ

Best

Super veryful this video

If i have 1000 nos.of sales person then how many time i will follow the step ?