automatically transfer data from one sheet to another in excel

  Рет қаралды 226,972

Shahab Islam

Shahab Islam

Күн бұрын

Пікірлер
@TwinkleTwinkleHuge
@TwinkleTwinkleHuge 2 жыл бұрын
Masha ALLAH Shahab Sahab Great Jazak ALLAH ALLAH Bless You
@devendrasharma3171
@devendrasharma3171 2 ай бұрын
Bahut badiya samjhya aap ne. ❤
@mohanch9333
@mohanch9333 2 жыл бұрын
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
@nayyarkamal5857
@nayyarkamal5857 Жыл бұрын
Amazing teaching style that can easily understand i will make sure to share as i can.
@mymomscuisine1176
@mymomscuisine1176 Жыл бұрын
Sir ap boht Acha sikhate hain
@tallypointaccountingclasse7456
@tallypointaccountingclasse7456 2 жыл бұрын
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..
@vinodganger4038
@vinodganger4038 5 ай бұрын
Lot of video view on advance, these is what I want automatically transfer Dat thank you sir
@muhammadzulnaurain4837
@muhammadzulnaurain4837 3 жыл бұрын
Good efforts from Saudia arabia
@nargistech508
@nargistech508 3 жыл бұрын
Nargis Tech
@shahabislam4912
@shahabislam4912 3 жыл бұрын
Thanks and welcome
@AjayThakur-kd8tg
@AjayThakur-kd8tg Жыл бұрын
You are very encouraging and promoting 😊😊😊
@Mystaffingonline
@Mystaffingonline 3 жыл бұрын
sir outstanding awala awala
@scc500
@scc500 3 жыл бұрын
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.
@Englishstory-
@Englishstory- Жыл бұрын
Bhot hi Ala ❤❤❤❤
@hamidhamidsatter4399
@hamidhamidsatter4399 2 жыл бұрын
Dear shahab Islam, excellent & brilliant teaching. Regards, Hamid
@manjit.sarania
@manjit.sarania 2 жыл бұрын
Thank you for your teaching on automatic data transferring trick
@shahabislam4912
@shahabislam4912 2 жыл бұрын
You are most welcome
@muhammadshakeel4482
@muhammadshakeel4482 3 жыл бұрын
Assalamoalaykum marvellous performance MashaAllah greatest
@nargistech508
@nargistech508 3 жыл бұрын
Nargis Tech
@arlofrancis5374
@arlofrancis5374 3 жыл бұрын
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 =)
@areslyle395
@areslyle395 3 жыл бұрын
@Arlo Francis Definitely, have been using instaflixxer for months myself :)
@SonuRaj-zp8ik
@SonuRaj-zp8ik Жыл бұрын
Very important and useful. Thanks🙏🙏🙏❤
@shahabislam4912
@shahabislam4912 Жыл бұрын
Most welcome 😊
@rayhanbd0
@rayhanbd0 2 жыл бұрын
Excellent boss. I am searching for it. Thanks
@shahabislam4912
@shahabislam4912 2 жыл бұрын
Most welcome
@hamidhamidsatter4399
@hamidhamidsatter4399 2 жыл бұрын
Dear shahab Islam, outstanding Video & massive Advice, amazing, cute,wonderful great, super, kindly more Advance in excel regarding Conditional formatting. Warm regards, Hamid.
@filmschannal28
@filmschannal28 Ай бұрын
Zbr10 hai
@AsadShaheenAkram
@AsadShaheenAkram Жыл бұрын
Excellent! Auto Update - Good Technique
@shahabislam4912
@shahabislam4912 Жыл бұрын
Thanks!
@qayoomaslami
@qayoomaslami 2 ай бұрын
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 ?
@rajpatel4596
@rajpatel4596 4 ай бұрын
Good 👍👍❤❤❤❤
@RAJANADEEMish
@RAJANADEEMish Жыл бұрын
Salam o Alykum sir
@muhammadkhalid7373
@muhammadkhalid7373 Жыл бұрын
sir thanks sir agr hum data paste krty hen tu kya auto sb sheet meh catagorywise ajayega?
@premdippremdip56
@premdippremdip56 3 жыл бұрын
Restaurant monthly and weekly food inventory video please upload kijia
@Moizfoodi
@Moizfoodi 3 жыл бұрын
Amazing techniques .....great sir jee....Shabir - Dubai
@shahabislam4912
@shahabislam4912 3 жыл бұрын
Many many thanks
@devenderkumar1220
@devenderkumar1220 Жыл бұрын
I like it..Thnks!
@muhammadshakeel4482
@muhammadshakeel4482 3 жыл бұрын
Marvelllous JazakAllah Aameen
@abdurraqeeb557
@abdurraqeeb557 2 жыл бұрын
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.
@shahabislam4912
@shahabislam4912 2 жыл бұрын
kzbin.info/door/cOsbNCxgUZMPoHEI1w-1RAsearch?query=match%20and%20vlookup
@navidaslam101
@navidaslam101 2 жыл бұрын
kiya ish tarah ap party ka ledger banna saghtay hai????
@ArshadAliIslamicchannelislam
@ArshadAliIslamicchannelislam 8 ай бұрын
GOOD JOB
@onlyexcel493
@onlyexcel493 3 жыл бұрын
Very helpful and useful video sir
@shahabislam4912
@shahabislam4912 3 жыл бұрын
Keep watching
@sandhyasenora3950
@sandhyasenora3950 9 ай бұрын
Hi sir , will this work on Google sheet also??
@fragrenceful
@fragrenceful 3 жыл бұрын
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
@shahabislam4912
@shahabislam4912 3 жыл бұрын
LINK BOOKMARK OPTION SE
@fragrenceful
@fragrenceful 3 жыл бұрын
@@shahabislam4912 matlub bookmark options se sheets ko link Karna hai
@Mystaffingonline
@Mystaffingonline 3 жыл бұрын
sir really bundle of thanks you are master mind of excel
@shahabislam4912
@shahabislam4912 3 жыл бұрын
Most welcome
@Mystaffingonline
@Mystaffingonline 3 жыл бұрын
@@shahabislam4912 sir i have difficulty in this sheet
@Mystaffingonline
@Mystaffingonline 3 жыл бұрын
@@shahabislam4912 sir can you send me your email / any other contact channel please
@RAJANADEEMish
@RAJANADEEMish Жыл бұрын
I want my excel data to my others Xcel forms data sheets ? Need you help plz
@danishhussain-u2k
@danishhussain-u2k Жыл бұрын
Ye formula kisi or file sheet pe apply ho skta h
@hafiztahir9760
@hafiztahir9760 Жыл бұрын
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
@Anaskhan-xo4yc
@Anaskhan-xo4yc 2 жыл бұрын
world clint k kch batye
@NaturalRemidies
@NaturalRemidies 2 жыл бұрын
Good way
@juzermajal8489
@juzermajal8489 3 жыл бұрын
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
@vandanasuthar7324
@vandanasuthar7324 2 жыл бұрын
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
@rajkumarmedepalli5539
@rajkumarmedepalli5539 2 жыл бұрын
Nice and very helpful
@shahabislam4912
@shahabislam4912 2 жыл бұрын
Thanks a lot
@sidrakhatun
@sidrakhatun 8 ай бұрын
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
@hameedkhankhan3285
@hameedkhankhan3285 3 жыл бұрын
Sir, Assalamualaikum, Agr hm isme new item add krna chahe to kaise krenge. Pl.tell me & Show in video.
@abduljabbar7795
@abduljabbar7795 Жыл бұрын
Same cash book ledger methoed . Right sir
@shahabislam4912
@shahabislam4912 Жыл бұрын
Yes, correct
@anshul4541
@anshul4541 2 жыл бұрын
Can we do the same in Google sheet?
@irshadhusain-b7c
@irshadhusain-b7c Жыл бұрын
Sir thanks that's good
@shahabislam4912
@shahabislam4912 Жыл бұрын
Welcome
@PradipKumar-pq3hf
@PradipKumar-pq3hf Жыл бұрын
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 ??
@jaisheo3776
@jaisheo3776 Жыл бұрын
Sir ek sheet me type karu or us naam se dusra sheet auto create ho kar usme data entry ho sakta hai kya
@shahabislam4912
@shahabislam4912 Жыл бұрын
yes
@zahidbadshahrzi3930
@zahidbadshahrzi3930 3 жыл бұрын
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?
@shahabislam4912
@shahabislam4912 3 жыл бұрын
g he.
@Rahul93030
@Rahul93030 3 ай бұрын
Sir yadi double course lena ho ek sheet me tab kaise hoga
@BhagatRAm-wx2oo
@BhagatRAm-wx2oo Жыл бұрын
Sir agar hm close karke fir kam krte hai to automatic data transfer nhi hota
@zahidwazir2659
@zahidwazir2659 3 жыл бұрын
Great work. Sir i want to do some work in excel VBA for development project. I need help ?
@dhananjaylambodari
@dhananjaylambodari Жыл бұрын
Is this also available in google sheets???
@shahabislam4912
@shahabislam4912 Жыл бұрын
No
@vardangupta8908
@vardangupta8908 8 ай бұрын
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
@kavimangalsharma8539
@kavimangalsharma8539 10 ай бұрын
If we delete any data from master sheet, will it automatically get deleted from these sheets?
@AnkitJain-ts1vl
@AnkitJain-ts1vl Жыл бұрын
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??
@KavitaKumari-cf1kt
@KavitaKumari-cf1kt 3 жыл бұрын
Good
@neilfernandas569
@neilfernandas569 Жыл бұрын
Can I transfer two cources to one sheet. Example was for one cource
@shaifulislam6746
@shaifulislam6746 3 жыл бұрын
Nice
@MuhammadSajid-r8k
@MuhammadSajid-r8k Жыл бұрын
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.
@sbskmusicmind
@sbskmusicmind Жыл бұрын
Thank u sir
@anjuagarwal8885
@anjuagarwal8885 11 ай бұрын
Sir when i am using call function and then entering the data then it is not visible in another sheet what should i do
@islamicvdovisionyousufharo8902
@islamicvdovisionyousufharo8902 Жыл бұрын
SIR AKHRI ENTRY DATA CONTINUE M ERROR AJATA HAI
@qadeerahmad481
@qadeerahmad481 2 жыл бұрын
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
@ranispakistanicuisine4172
@ranispakistanicuisine4172 Жыл бұрын
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
@09shirish
@09shirish 2 жыл бұрын
You should provide nice information ! thanks for sharing !
@irshadhusain-b7c
@irshadhusain-b7c Жыл бұрын
Sir this excel sheet witch version
@shahabislam4912
@shahabislam4912 Жыл бұрын
2019
@velocitypta
@velocitypta 2 жыл бұрын
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
@SujatKhanOfficial
@SujatKhanOfficial Жыл бұрын
MASHAALLAH
@Linguistics.Linguistics
@Linguistics.Linguistics 10 ай бұрын
سر اگر ہم نے AUTOCAD ورک شیٹ میں مارننگ اور ایوننگ کی الگ الگ ٹیبل میں کرنا چاہیں تو 2 MACROS کیسے رن کریں گے AUTOCAD والی شیٹ میں؟
@kisdomania
@kisdomania Жыл бұрын
Agar ek hi sheet me multiple macro apply karne ho to wo kaise karenge
@zubairvirani2903
@zubairvirani2903 Жыл бұрын
Sir data to Dori sheet MA ja raha hai agar account chalana Ho to kase har party ka har sheets MA + end - auto Ho plz Help 😊❤
@Mother_Wings
@Mother_Wings 10 ай бұрын
Master file mai Change hone par auto update kese hoga...
@mohdshafinajar3650
@mohdshafinajar3650 2 жыл бұрын
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
@nagmakhan652
@nagmakhan652 5 ай бұрын
Hey how can I do the same in Google sheet ??
@shahabislam4912
@shahabislam4912 5 ай бұрын
I will check and let you know
@shaubahmed1571
@shaubahmed1571 6 ай бұрын
How to make new macro records if it is number
@monu8524
@monu8524 Жыл бұрын
Sir is macro ka use kaha hua? Please clear kare
@ajay-I23
@ajay-I23 Жыл бұрын
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.
@KAMLESHKUMAR-yq2bf
@KAMLESHKUMAR-yq2bf 10 ай бұрын
Automatic data transfer nahi ho raha hai
@khannazim100
@khannazim100 4 ай бұрын
facing difficulty in updating new data, please help
@sanjeetkb4302
@sanjeetkb4302 Жыл бұрын
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
@shahabislam4912
@shahabislam4912 Жыл бұрын
kzbin.info/www/bejne/nZjTaYp3d6p-j9E
@AdnanYTOffical
@AdnanYTOffical 3 жыл бұрын
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
@LetsgetSmarter
@LetsgetSmarter Жыл бұрын
Sir can I transfer data using two specification like morning Autocad and evening autocad. if yes, then how
@qalidali893
@qalidali893 3 жыл бұрын
Good man
@nargistech508
@nargistech508 3 жыл бұрын
Nargis Tech please
@msi________2760
@msi________2760 2 жыл бұрын
Dear Sir, i have one Problem in file While using Micro please help me to fix it....!
@itsmesujoy9351
@itsmesujoy9351 2 жыл бұрын
Agar multiple column se select karnna hai to? Suppose autocad 4 colum me hai
@MuhammadTariq-ti9vu
@MuhammadTariq-ti9vu Жыл бұрын
If criteria is Class Grade 4, then?
@muhammadajmal7013
@muhammadajmal7013 2 жыл бұрын
Can we copy or move data from one excel sheet to other using paste special
@riazsammad7604
@riazsammad7604 3 жыл бұрын
Sir please full and finale settlement video
@ramsajivansahu4585
@ramsajivansahu4585 2 жыл бұрын
सर मान लो एक लम्बी लिस्ट है मेडिसिन की जिसमे हर मेडिसिन का अलग अलग कोड है । लेकिन कई मेडिसिन ऐसी हैं जिनका मतलब एक ही मेडिसिन के अलग अलग कोड हैं जैसे D140, LPD140, LPD140E एक ही मेडिसिन amoxycillin 500 mg cap. के कोड हैं । इस लिस्ट के लिए सर्च बॉक्स बनाना बताये जिसमे amox type करते ही amoxycillin capsules. inj की अलग अलग स्ट्रेंथ शो हो और amoxycilin 500 को सेलेक्ट करते ही उसके सभी कोड्स वाली लिस्ट शो हो जाये उसकी क्वांटिटी, बैच no. एक्सपायरी डेट etc
@vipulmishra6694
@vipulmishra6694 11 ай бұрын
Sir ek help chaiyae
@muhammadsaeedhabiburrehman505
@muhammadsaeedhabiburrehman505 2 жыл бұрын
اسلام وعلیکم. ایک گروپ.جس 70 انچارج اور رکن 2200 سو سے زیادہ ہیں. اس کی ترتیب کے مطلق معلومات شیر کریں. شکریہ
@amitde8876
@amitde8876 3 жыл бұрын
Thanks
@mymomscuisine1176
@mymomscuisine1176 Жыл бұрын
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
@shahabislam4912
@shahabislam4912 Жыл бұрын
g ye topic upload he channel p
@muhammadparyal6269
@muhammadparyal6269 2 жыл бұрын
sir data to aajata ha lekin last jab entery karta hon doosri sheet pe nhn ja rahi ha please guid me sir.
@webWala
@webWala 2 жыл бұрын
how to fill same data on same sheet in different column
@rajatrakhitmishra
@rajatrakhitmishra 2 жыл бұрын
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 🙏
@Saleembutt-i5b
@Saleembutt-i5b Жыл бұрын
السلام علیکم اگر ہم ایک ہی رو پر جنوری فروری مارچ ایک اسٹوڈنٹ کی فیس سیٹ کرانا چاہتے ہیں تو اس کی ڈیٹ اینٹری کیسے ہوئی اس کا فارمولا کیا ہوگا شکریہ
how to maintain petrol pump accounts in Excel Hindi
27:23
Shahab Islam
Рет қаралды 174 М.
Consolidation in Excel (Hindi) | How to Consolidate Data in Excel
6:32
PowerEx by Jitendra
Рет қаралды 496 М.
СИНИЙ ИНЕЙ УЖЕ ВЫШЕЛ!❄️
01:01
DO$HIK
Рет қаралды 3,3 МЛН
小丑教训坏蛋 #小丑 #天使 #shorts
00:49
好人小丑
Рет қаралды 54 МЛН
REAL or FAKE? #beatbox #tiktok
01:03
BeatboxJCOP
Рет қаралды 18 МЛН
How to Move Data Automatically Between Excel Files
11:37
Kenji Explains
Рет қаралды 229 М.
How to Pull Data from Another Sheet based on Criteria in Excel & Google Sheets?
8:27
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 1 МЛН
Google Sheets: Sync Data from One Sheet to Another
6:01
Jason Aillaud
Рет қаралды 253 М.
СИНИЙ ИНЕЙ УЖЕ ВЫШЕЛ!❄️
01:01
DO$HIK
Рет қаралды 3,3 МЛН