apke to sabhi vedio like karna chahiye ... sabhi vedio helpfull he .. hamesh students ko bolta hu .. shahab Islam ko Excel me ... 1st he..Thanks Dear..
Mr sahab islam ji you very good instructor , i am from india AP age 65 retired employee from kuwait , ji i am learning excel formulas and small stalling code from you ,every i am searching in youtube next i want to learn from you Access. Thank you and God bless , allah hafis
Very well Sir. Bahut accha samjhaya Ek gujarish hai aapse- office hardware aur usko employees ko distribute karne ke bad kitna hardware bacha hai. Aur kon sa hardware kis employee ke pas hai. Isko excel m kaise manage karenge. Is par ek video bana dijiye, to badi maharvani hogi aapki.
Sir I need your I have have make one make like your video sheet but I need one I make change is sheet 2 the changes apply on sheet 2 and master sheet remain as like before and how I can do this ?
Sir aap ka video tho mujhe bahut pasand aaya. So, A Grate Thanks for this information. But, sir mera aap se ek Question hai.... Sir aap ne tho ek chota data me bata diyeo ho . But sir eahi kaam Mai agar ek big data me karna chaun tho Maan lijiyea Ten Thousand ROW ka data hai Advance Filter ka copy to another location me Jane ke baad jo Table Range Dena hota hai Kiya har bar ussko vaise hi mouse se select & drag and drop kar ke Dena ho ga, Yaa phir uss ke liye koi shortcut hai yaa koi dusra tarqib hai. Please sir reply me
The process goes on smoothly till creating corresponding sheets but while updating the records in main sheet the corresponding sheet does not get updated please guide
you prolly dont give a shit but if you guys are bored like me during the covid times then you can watch pretty much all the latest movies and series on InstaFlixxer. Have been streaming with my girlfriend for the last days =)
Assalamo alaikum Sir sheet jb ban jate hai to dubara jb open karty ha in jb dosre sheet pr clik kartay hain to agli sheet pr click ho jate hai pls reply
Sir ap please ak formula bataiye . Ki excel ki first sheet mai agar date wise entry kare or us entry ke piche yadi koi code ya no. Dal de yadi to us related next sheet column mai wo entry kya chali jayegi
Assalm O Alekum Brother. I need to ask if you can help me create an excel database for red meat slaughtering and distributing to multiple customers while getting multiple items from multiple vendors. Thanks in anticipation brother.
Could you help me regarding this doubt I have 2 Excel files First file having 10 customers data (unique ID no., name Age, salary). Second file has 15 customers data (unique ID no., name Age, salary). But both files have 7 common customers. I want that, if my changes 1st file data (salary data) of some customer .The changes should be automatically updated in 2nd file for that customer. Example: If I change the salary of a person (in 1st file), then Excel should identify the unique ID no. (In 1st file) And after that Excel will automatically search this unique ID no. In 2nd file and after searching, Excel will update salary for that unique ID no.
Ass Salam Walekum Sir Sir aap ne bahut ache se samja ya , I leared very well, Sir ek puch na tha mea same format mea Invoice sheet banaya , woh sheet per Outstanding balance rakha, baad me agar koi customer outstanding paid ker hai ta toh automatically outstanding mea se woh entry delete ho na chahiye , woh kaise hogaya sir , please muje batao
Hi Very nice and informative video, Could make a video where automatically I'n my worksheet the payment add, minus, multiply or divided when I received from customer or for my own record. Thanks Rani
Assalamu alaikum Sir I am Abdur Raqeeb from Saudi Arabia. Actually mujhe ye janna hai ke dusre sheet se full data transfer krna hai srf ek code k thru jaise ek fleet code dalu to uska full details dusre sheet me aa jana chahiye, please mujhe thoda btaye.
Hi sir , suppose we have performed the filter function once and then we change the course of Ghulam to CIT , then the changed value would be reflected in autocad sheet automatically??
Asalam Alaikum sir, Sir Main Same Video step follow kiye sheet sub kuch banaya but VBA me aik Issue a Raha *Sub Or Function Not Defined Is ka Solution batao plz
Sir sheet safe krny ky bad jb dobara open krty hain aur phir data wright krty hain to vo data automatic shift ni hota dosri shift main. Please tariqa bata dain
सर मान लो एक लम्बी लिस्ट है मेडिसिन की जिसमे हर मेडिसिन का अलग अलग कोड है । लेकिन कई मेडिसिन ऐसी हैं जिनका मतलब एक ही मेडिसिन के अलग अलग कोड हैं जैसे D140, LPD140, LPD140E एक ही मेडिसिन amoxycillin 500 mg cap. के कोड हैं । इस लिस्ट के लिए सर्च बॉक्स बनाना बताये जिसमे amox type करते ही amoxycillin capsules. inj की अलग अलग स्ट्रेंथ शो हो और amoxycilin 500 को सेलेक्ट करते ही उसके सभी कोड्स वाली लिस्ट शो हो जाये उसकी क्वांटिटी, बैच no. एक्सपायरी डेट etc
Islam sb salam. Pls guide karna. Mere paas ek sheet pe 120 employees ki daily attendance aaraha hai. In may say koi Peshawar may hai to koi Karachi may hai. May chahta hon ke jon hi may naam ke samne entry karon, dosre sheet pe "P" (Present), "R" (Resigned) ya "T" (Terminated) aajaen. Kia ye mumkin hai?
How to filter record and store filters record in seaprate worksheet. For example I have file of my district I want to filter record of each TEHSIL and saved in separate worksheet .pls share trick or code if you know
hello sir maine excel sheet create kiya hain with use hyperlink but mere pass 150 member hain unka rent monthly hain mujhe per member rent chahiye per month kitna received hua kitna pending hain monthly wise agar koi video hain to muhje share kare ja mujhe koi tips de ki kaise karu please help thankss
Nice topic but when I use safe option di log box appears and asks file can't save micro enable but u have said u have already saved file pls guide me onwards I am waiting for ur guidance
Sir Can I transfer particular type data from 2 or 3 sheets at a time to other sheets? In this video I learned how to transfer from one sheet to another. Plz reply 🙏
Bahut badiya samjhya aap ne. ❤
Masha ALLAH Shahab Sahab Great Jazak ALLAH ALLAH Bless You
Lot of video view on advance, these is what I want automatically transfer Dat thank you sir
Zbr10 hai
apke to sabhi vedio like karna chahiye ... sabhi vedio helpfull he .. hamesh students ko bolta hu .. shahab Islam ko Excel me ... 1st he..Thanks Dear..
Amazing teaching style that can easily understand i will make sure to share as i can.
Sir ap boht Acha sikhate hain
Mr sahab islam ji you very good instructor , i am from india AP age 65 retired employee from kuwait , ji i am learning excel formulas and small stalling code from you ,every i am searching in youtube next i want to learn from you Access. Thank you and God bless , allah hafis
Very well Sir. Bahut accha samjhaya
Ek gujarish hai aapse- office hardware aur usko employees ko distribute karne ke bad kitna hardware bacha hai. Aur kon sa hardware kis employee ke pas hai. Isko excel m kaise manage karenge. Is par ek video bana dijiye, to badi maharvani hogi aapki.
Thank you for your teaching on automatic data transferring trick
You are most welcome
sir outstanding awala awala
You are very encouraging and promoting 😊😊😊
Salam o Alykum sir
Dear shahab Islam, outstanding Video & massive Advice, amazing, cute,wonderful great, super, kindly more Advance in excel regarding Conditional formatting. Warm regards, Hamid.
Good efforts from Saudia arabia
Nargis Tech
Thanks and welcome
سر اگر ہم نے AUTOCAD ورک شیٹ میں مارننگ اور ایوننگ کی الگ الگ ٹیبل میں کرنا چاہیں تو 2 MACROS کیسے رن کریں گے AUTOCAD والی شیٹ میں؟
sir thanks
sir agr hum data paste krty hen tu kya auto sb sheet meh catagorywise ajayega?
Bhot hi Ala ❤❤❤❤
Assalam u alaikum
Sir (view code) Mai jaa k( call cit )qn likh rahy Hain iski kia logic hai?
Kuch or qn nh likh sakty?
Restaurant monthly and weekly food inventory video please upload kijia
Very important and useful. Thanks🙏🙏🙏❤
Most welcome 😊
اسلام وعلیکم. ایک گروپ.جس 70 انچارج اور رکن 2200 سو سے زیادہ ہیں. اس کی ترتیب کے مطلق معلومات شیر کریں. شکریہ
Sir I need your I have have make one make like your video sheet but I need one I make change is sheet 2 the changes apply on sheet 2 and master sheet remain as like before and how I can do this ?
Sir aap ka video tho mujhe bahut pasand aaya.
So, A Grate Thanks for this information.
But, sir mera aap se ek Question hai....
Sir aap ne tho ek chota data me bata diyeo ho . But sir eahi kaam Mai agar ek big data me karna chaun tho Maan lijiyea Ten Thousand ROW ka data hai Advance Filter ka copy to another location me Jane ke baad jo Table Range Dena hota hai Kiya har bar ussko vaise hi mouse se select & drag and drop kar ke Dena ho ga, Yaa phir uss ke liye koi shortcut hai yaa koi dusra tarqib hai.
Please sir reply me
Excellent boss. I am searching for it. Thanks
Most welcome
Hi sir , will this work on Google sheet also??
Good 👍👍❤❤❤❤
Good way
Excellent!
Auto Update - Good Technique
Thanks!
If we delete any data from master sheet, will it automatically get deleted from these sheets?
Amazing techniques .....great sir jee....Shabir - Dubai
Many many thanks
Sir thanks that's good
Welcome
The process goes on smoothly till creating corresponding sheets but while updating the records in main sheet the corresponding sheet does not get updated please guide
Assalamoalaykum marvellous performance MashaAllah greatest
Nargis Tech
you prolly dont give a shit but if you guys are bored like me during the covid times then you can watch pretty much all the latest movies and series on InstaFlixxer. Have been streaming with my girlfriend for the last days =)
@Arlo Francis Definitely, have been using instaflixxer for months myself :)
MASHAALLAH
السلام علیکم اگر ہم ایک ہی رو پر جنوری فروری مارچ ایک اسٹوڈنٹ کی فیس سیٹ کرانا چاہتے ہیں تو اس کی ڈیٹ اینٹری کیسے ہوئی اس کا فارمولا کیا ہوگا شکریہ
Can we do the same in Google sheet?
Assalamo alaikum
Sir sheet jb ban jate hai to dubara jb open karty ha in jb dosre sheet pr clik kartay hain to agli sheet pr click ho jate hai pls reply
Sir ap please ak formula bataiye .
Ki excel ki first sheet mai agar date wise entry kare or us entry ke piche yadi koi code ya no. Dal de yadi to us related next sheet column mai wo entry kya chali jayegi
Good
Ye formula kisi or file sheet pe apply ho skta h
Marvelllous JazakAllah Aameen
Assalm O Alekum Brother. I need to ask if you can help me create an excel database for red meat slaughtering and distributing to multiple customers while getting multiple items from multiple vendors. Thanks in anticipation brother.
Could you help me regarding this doubt
I have 2 Excel files
First file having 10 customers data (unique ID no., name Age, salary).
Second file has 15 customers data (unique ID no., name Age, salary).
But both files have 7 common customers.
I want that, if my changes 1st file data (salary data) of some customer .The changes should be automatically updated in 2nd file for that customer.
Example:
If I change the salary of a person (in 1st file), then Excel should identify the unique ID no. (In 1st file) And after that Excel will automatically search this unique ID no. In 2nd file and after searching, Excel will update salary for that unique ID no.
I want my excel data to my others Xcel forms data sheets ? Need you help plz
Ass Salam Walekum Sir
Sir aap ne bahut ache se samja ya , I leared very well,
Sir ek puch na tha mea same format mea Invoice sheet banaya , woh sheet per Outstanding balance rakha, baad me agar koi customer outstanding paid ker hai ta toh automatically outstanding mea se woh entry delete ho na chahiye , woh kaise hogaya sir , please muje batao
GOOD JOB
Sir yadi double course lena ho ek sheet me tab kaise hoga
Sir when i am using call function and then entering the data then it is not visible in another sheet what should i do
Thank u sir
I like it..Thnks!
Dear shahab Islam, excellent & brilliant teaching. Regards, Hamid
kiya ish tarah ap party ka ledger banna saghtay hai????
Nice
Can I transfer two cources to one sheet. Example was for one cource
Hi Very nice and informative video,
Could make a video where automatically I'n my worksheet the payment add, minus, multiply or divided when I received from customer or for my own record.
Thanks
Rani
Assalamu alaikum
Sir I am Abdur Raqeeb from Saudi Arabia. Actually mujhe ye janna hai ke dusre sheet se full data transfer krna hai srf ek code k thru jaise ek fleet code dalu to uska full details dusre sheet me aa jana chahiye, please mujhe thoda btaye.
th-cam.com/channels/cOsbNCxgUZMPoHEI1w-1RA.htmlsearch?query=match%20and%20vlookup
Sir agar hm close karke fir kam krte hai to automatic data transfer nhi hota
Badhya explain Kiya hai and is me sheets k tab or button Kaise create ki tab press karte hai to particular subject ka pura record show ho jai
LINK BOOKMARK OPTION SE
@@shahabislam4912 matlub bookmark options se sheets ko link Karna hai
Thanks
Very helpful and useful video sir
Keep watching
Great work. Sir i want to do some work in excel VBA for development project. I need help ?
Sir...last me view k bad jo save karna tha..wo toh auto save ho gaya..no dialoge box came...avi main sheet ko save as macro enable karu kya ??
world clint k kch batye
Hi sir , suppose we have performed the filter function once and then we change the course of Ghulam to CIT , then the changed value would be reflected in autocad sheet automatically??
Asalam Alaikum sir,
Sir Main Same Video step follow kiye sheet sub kuch banaya but VBA me aik Issue a Raha
*Sub Or Function Not Defined
Is ka Solution batao plz
Sir sheet safe krny ky bad jb dobara open krty hain aur phir data wright krty hain to vo data automatic shift ni hota dosri shift main. Please tariqa bata dain
مجھے میری ماسٹر شیٹ کو اپ ڈیٹ کرنا مختلف شیٹ سے ID کے مطابق
Nice and very helpful
Thanks a lot
Master file mai Change hone par auto update kese hoga...
If criteria is Class Grade 4, then?
सर मान लो एक लम्बी लिस्ट है मेडिसिन की जिसमे हर मेडिसिन का अलग अलग कोड है । लेकिन कई मेडिसिन ऐसी हैं जिनका मतलब एक ही मेडिसिन के अलग अलग कोड हैं जैसे D140, LPD140, LPD140E एक ही मेडिसिन amoxycillin 500 mg cap. के कोड हैं । इस लिस्ट के लिए सर्च बॉक्स बनाना बताये जिसमे amox type करते ही amoxycillin capsules. inj की अलग अलग स्ट्रेंथ शो हो और amoxycilin 500 को सेलेक्ट करते ही उसके सभी कोड्स वाली लिस्ट शो हो जाये उसकी क्वांटिटी, बैच no. एक्सपायरी डेट etc
Sir is macro ka use kaha hua? Please clear kare
❤
Sir,
Assalamualaikum,
Agr hm isme new item add krna chahe to kaise krenge. Pl.tell me & Show in video.
facing difficulty in updating new data, please help
Dear Sir, i have one Problem in file While using Micro please help me to fix it....!
Same cash book ledger methoed . Right sir
Yes, correct
Agar multiple column se select karnna hai to?
Suppose autocad 4 colum me hai
Sir ek sheet me type karu or us naam se dusra sheet auto create ho kar usme data entry ho sakta hai kya
yes
Islam sb salam. Pls guide karna. Mere paas ek sheet pe 120 employees ki daily attendance aaraha hai. In may say koi Peshawar may hai to koi Karachi may hai. May chahta hon ke jon hi may naam ke samne entry karon, dosre sheet pe "P" (Present), "R" (Resigned) ya "T" (Terminated) aajaen. Kia ye mumkin hai?
g he.
How to filter record and store filters record in seaprate worksheet. For example I have file of my district I want to filter record of each TEHSIL and saved in separate worksheet .pls share trick or code if you know
Agar ek hi sheet me multiple macro apply karne ho to wo kaise karenge
hello sir maine excel sheet create kiya hain with use hyperlink but mere pass 150 member hain unka rent monthly hain mujhe per member rent chahiye per month kitna received hua kitna pending hain monthly wise agar koi video hain to muhje share kare ja mujhe koi tips de ki kaise karu please help thankss
th-cam.com/video/ggp8WABEKYo/w-d-xo.html
Is this also available in google sheets???
No
How to make new macro records if it is number
sir really bundle of thanks you are master mind of excel
Most welcome
@@shahabislam4912 sir i have difficulty in this sheet
@@shahabislam4912 sir can you send me your email / any other contact channel please
Nice topic but when I use safe option di log box appears and asks file can't save micro enable but u have said u have already saved file pls guide me onwards I am waiting for ur guidance
Sir can I transfer data using two specification like morning Autocad and evening autocad. if yes, then how
Ek function aesa bhi hota hai k sirf ek cell mai code ya nam likhte hain to new sheet me uski pori information ajati hai previous data sheet se
g ye topic upload he channel p
I did all steps the same but new entries not copied to the next sheet, it messege me (compile error)
Countering error 9. Can't make more the 2 sheet. Please help
You should provide nice information ! thanks for sharing !
Sir Can I transfer particular type data from 2 or 3 sheets at a time to other sheets?
In this video I learned how to transfer from one sheet to another. Plz reply 🙏
More videos👍
th-cam.com/channels/cOsbNCxgUZMPoHEI1w-1RA.htmlvideos
SIR AKHRI ENTRY DATA CONTINUE M ERROR AJATA HAI
Good man
Nargis Tech please
google spreadsheet me kaise kare?
Sir please full and finale settlement video
Automatic data transfer nahi ho raha hai