SURPRISING ! Excel Trick To Link Data across Multiple Sheets & Workbooks

[@monuverma_official]

Sir aap jo video banaye the automatic invoice and inventory vala usi me aap party ki payment managment day book bana dijiye please........🙏🏻🙏🏻🙏🏻

[@irfanvlogandtaste]

bahtareen vedio sir g i am your fig fan from pakistan aapki waja se muje excel ke istimaaal se office main pazirayiiii melti hain

[@arunkumarsinghark3024]

🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

[@SANJAYPRAJAPATI-gc1dt]

Very nice sir

[@nitinsapariya8858]

बहुत ही बढ़िया ट्रिक्स है। धन्यवाद।

[@chetandorlikar8210]

Hi Deepak, Usually I always watch your videos and learn many new thing's which helps me in my official works. After watching this video, I am glad and really want to share my expression with you. I appreciate your knowledge and skills which you have developed by yourself and we thank you that you sharing such knowledge and skills without expecting any return from us, whereas many institute charge lots of money for same training and knowledge. Many love and wishes to you brother. Stay healthy and educate us always. Thank you, Chetan.

[@mohd.billalhossain5072]

Nice Video

[@ajitmishra4231]

TAHNK,S SIR

[@rizwan-2288]

Very good explaining bro thanks

[@bijaytanty8434]

Thanks 🙏

[@pradeepnegi7523]

Good sir

[@vickycomputer123]

by watching UR videos I learnt lot of new shortcuts, formulas, tricks of excel..... your videos are really good & easy to understand.

[@asmrindia]

Great

[@smtminabensata3746]

Nice Bro

[@dkrai683]

great formula to hide '0' via format cell setting. thank you sir for new knowlege. Your this vdo is giving us new knowlede but I would like to inform you that this process is too lengthy and may be critical for beginers. I did always use a formula "=sheet1!A1" and drag in full or partial sheet to link one or more sheets. Thank you sir for giving us great knowlegde. (Deepak)

[@vikasjangra3563]

thanku sir bahut work kam kar diya apne ....salute

[@halwahekya3345]

Thanks yr👍

[@aanchalkashyap9391]

Super se uper class 👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍too good sir 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

[@Himanshu_Panwar_Dhanpati.Uk11]

4thcomment. भाई जी सादर अभिवादन 🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻। Aap ki videos sach me bahut informative hoti hain.

[@vikashmourya8964]

Genius sir has come....thanks

[@channelshahabuddin]

Thank for sharing valuable knowledge 👍

[@Pankajkumar-yv5dr]

Thanks by heart Deepak👌👌👌

[@sarvodayaconventvidisha1757]

Super

[@gyanendrasikarwar8702]

First like and comment

[@shahnazbano3739]

I LIKE UR VIDEOS SIR

[@RahulKumar-ly6ly]

Thanks a lot sir

[@vijaymete250]

best

[@kawmalmustafa1537]

Thanks you my dear sir very nice vedio

[@saurabhkatakwar8942]

Thank you Thank you Thank you...

[@vishaltanwar8318]

Thank you so much sir maine he aapko pehle kabhi es par video banane ko bola tha 😊

[@tasleeemahmad3466]

Very helpful trick sir . Thanks you sir

[@shiprasingh3806]

wow

[@barjeshkumarsharma6495]

I need to connect two online spreadsheet.. what would I do please help if you have any suggestions...thx....

[@barjeshkumarsharma6495]

I have found the way, how to connect two google sheets, use Below =Importrange("Sheet Urls","Tab name! Range") Thx.....

[@nareshbhardwaj1287]

Sir, aap ki jo gst invoice wali video acchi thi Bill ko pdf format m export krna bhi acha h Kya aap ye bata skte ho ki Kaise datewise folder create ho jaye aur us din k sabhi invoice us folder m save ho jaye

[@akshayvibhar6092]

Thanks for sharing this knowledge

[@nafeesahmedkhannafees2857]

Bhai excel me bahot si sheet hai page A4 pe set for example Pay silp hai.. In sari sheets ko kaise eik sheet me ye sari paysilps pages wise kaise merge kareynge. Jaise employ 1. Ki page one pe employ 2 ki page two pe mastersheet me. Please reply.

[@Vibevideos-f3i]

1st comment 👍 wonderful trick..thank you 😊

[@niteshsoni7768]

Sir apki classes mil skti hai kya ??

[@ankurshah3224]

Sir CSS3 ke video kab upload karoge

[@pankaj_kumar_64]

Will it work if the file is shared on line with some one at distant place

[@Satyendra2022]

𝗧𝗵𝗮𝗻𝗸❤🌹🙏 𝘆𝗼𝘂💯🤜

[@onlinecomputerskills5024]

VERY NICE VIDEO

[@eklavyagyan4817]

Sir format cell custom pr ek detailed video please.

[@khalidalisubhanallah2947]

Very knowledgeable video

[@ShekharKumar-ll4rk]

Great video

[@taizoondean689]

Thanks bhai 👍

[@manikantkumar6819]

Sir aap programming ke upr v video banaye

[@amrishdhiman4255]

Wonderful video sir good luck 👍

[@m.twoodwork779]

Sir khatabook jesa kuch bataye .Thanks

[@mohdali7645]

Nice video. Lakin kya is k liya donong workbooks open hona chahiya. Agar master workbook open nahi ha to link update hoga?

[@abuhammad8652]

I hope you make A Tutorial about dppended combobox in excel vba userform. Thanks

[@satenderkumar-tb4jh]

Sir when I do pestlink date convert into number what I do please reply me

[@narayanbelkar7459]

Nice video 🙏

[@ashokbihari7433]

Nice 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

[@BharatKumar-fh7ei]

I got what is was searching 👍. It is possible to copy selected column instead of all column? If yes then how, please reply.

[@shaiknazir9236]

Sir please make a video on mail merge

[@amitchaudhary5541]

SIR.THANKS

[@bpyadavji]

You are great sir 👌🙏🙏

[@arunkumarsinghark3024]

क्या हम अलग अलग work book के sheet के कुछ selective columns को link, या macro use कैसे कर सकते हैं

[@Advanceuser1]

Love you dear friend I want monthly and annually slicers without using pivot table

[@zayedkhan6772]

plz sir make a video of VBA..full Explain it..plzz i need this...

[@mytechnosupport269]

Please make videos for google sheets users

[@uttamkumar-os2dy]

Excel ka 1 complete video upload kariya 🙏🙏🙏🙏🙏

[@singhbrajesh89]

Sir, how to highlight NA(invalid value) in a sheet using conditional formatting?

[@BaljinderSingh-he8ys]

Dear Sir, need your help for max function with different criteria in more than one column, i have a sample excel file to understand my problem..

[@PradeepKumar-tz8xp]

Sir. Date ka format 1990 ho rha ye kaise change hoga..

[@koushikmandal8311]

❤😊

[@p.meharprasadreddy7861]

Sir Can we serch the data name using serch tool

[@SandyKhanapure]

How to combine multiple sheet in to one sheet

[@paruljoshi2521]

👌👌👌

[@mohammadaijaz4901]

Sir, Table per Link nahi work kar raha ??? is ka solution bata den.

[@birendramaharjan868]

hlo deepak sir...yeh jo aapne sikhayi huyi trick kis kaam me implement hoga yeh bhi thoda bagyena sir..

[@pradeepnegi7523]

Bank data ke liye TDs ke liye

[@pardeepdhingra498]

🙏 Kya is method se sheet Ya workbook se kuch selective coloums ko bhi master me link kr sakte h ???

[@gkskhalid]

Amazing

[@samratmondal6110]

The video is very good if it is a little more advanced. And it doesn't matter if every student pays 500 rupees per month, what can be done in case he can pay less or more. Again, which student comes in the car. I want to know who did not pay in January, February or any other month. What to do in that case.

[@rafiullah6300]

Hi Deepak, Hope you are well, I am facing an issue that the paste link button is disabled, Please guide

[@arunkumarsinghark3024]

आपसे कैसे contact कर सकते हैं कोई mail id बताए, office data है मेरा रोज allocation होती है और work करके रोज report बनाकर भेजना होता है l इसे automated बना सकते हैं, macro use, link use कैसे करे एक बार query समझ लीजिए please sir 🙏🙏🙏

[@abcd7273]

Hello Deepak, If i have hyperlink on excel cell, can i access a prticular cell values through hyperlink to the new sheet?????

[@ishlamtanwar2509]

Sir zero se koi data entry se shikhna chahein to kitne din m complete data entry shikh skta h

[@kevinseeam4849]

Living legend

[@ameyshinde914]

Hi Sir, Can you help to link 1 workbook which contain multiple sheet and that sheet need to be link in multiple excel files.

[@vvnschool]

Row ya column insert karne ya delete karne par bhi ye kaam kaise karega

[@mayanarayan5723]

How to do MIS worksheets where most of the company are using today can u please help me can u do a video on that so that it will be useful

[@PrimeStar416]

Sir Excel me multiple cell link kaise kare

[@aasim143k]

Sir aapne data entry ki vidio banayi he... To kya hr jagah ese hi entry ki jati he.. 🤔🤔

[@rajnishkantgaur9745]

Sir multiple sheets se master sheet kaise banega plse sir

[@bjchavda9596]

Sir, Pls Let Us Know... If I Have A Master File... Whatever I Update In That File.. It Automatically Update in Other Excels... Is There Any Option???

[@bjchavda9596]

Means I Update One Excel,It Automatically Reflect in Other Connected Excels.. Please Help

[@sandeepzaildar8019]

Hello bro, how we can make a sheet of desired data from a master sheet if we make change in master sheet it also change in required sheet. Example- If we insert a column in master sheet it should be in desired sheet. Please tell simple and effective formula please.

[@Vairagi73]

sir... lekin is mein ek problem hai... agar aap ne linked workbook ka place badal diya to problem ho jati hai...

[@arunkumarsinghark3024]

Sir मेरी कुछ queries है please help 🙏🙏🙏

[@mahendrasharma1716]

I am buy and sell shares so tell me how can I maintain SHARE stocks data

[@singhbrajesh89]

If master sheet where data is linked is not open then if we change data in other sheet Wheather master sheet will be updated or not.If answer is no then how to update without opening master sheet

[@r.geducationssc2314]

😍😍

[@vinaydadhich]

बॉस, एक पुरानी फ़ाइल है, जिस में ड्रॉप डाउन लगा है, अब प्रॉब्लम ये है कि मूझे ओरिजिनल लिस्ट की सेल नही मिल रही, पूरी जहा लिस्ट है (लिस्ट range ह) सेल हाईड कर दी थी Please बताइये ना उस रेंज वाली सेल को कैसे फाइंड करू।

[@SandeepKumar-gb6st]

You have not told how to select coloums or we want selected columns only

[@isidjdjdjjd4721]

Sir time calculated salary sheet bnaoo ki 8 hour daily 30 din ki job me 10000 hai to 6 ghnte daily 26 din me kitni salary hogi or 12 hour daily 30 din me kitni hogii plzzzzzzzzz sirrrrr upload krdo is video ko pure KZbin pr esi koi video nai miliiii ####@

[@user-vinodkumar143]

कोई मेरा भी रिप्लाई देना एक वर्कबुक में तीन शीट प्र काम किया ह और उसमे से कोई एक ही शीट सेव करनी हो तो केसे करेगे

[@kumargoodvideoscreation9582]

Sir mujhe 4371 4803 4544 3678 #DIV/0! 2548 #DIV/0! 4232 #DIV/0! 4271 Ye data ko sum krna hai bina #DIV/0! Remove kiye. Sir pls help me mujhe se MIS ka Interview me puchha gya tha. Mai =Sum(iferror(range,0)) Use kr chuka hu Answer nhi aaya., Sir pls mera problem ka solution Bataye.

[@worldpeace2354]

मेरा मशवरा है कि तुम एकसेल के अतिरिक्त और भी टेक्निकल चीज पर अपने वीडियो बनाओ, साथ ही साथ अपने चेहरे को वीडियो में भी अवश्य दिखाओ।

[@DeepakEduWorld]

🤗

[@samratmondal6110]

I have more than 500 students. I know the total amount of money left for all the students. But I want to give notice to those who have money left in March and April. Please help me with how to do that