🔥 Quickly Combine Data from Multiple Sheets into One (new way)

Поделиться
HTML-код
  • Опубликовано: 25 ноя 2024
  • Learn how to quickly and easily combine data from multiple sheets into one in Excel with this step-by-step tutorial! Whether you're working with sales reports, budget spreadsheets, or any other data, combining data from different sheets can be a time-consuming task. In this video, we'll show you quick and easy method to streamline this process using excel new vstack function. Watch now to learn this vstack formula and become a pro at combining data from multiple sheets in microsoft excel!
    My Channels :
    A to Z Excel : bit.ly/3hQCRiw
    Deepak Techworld : bit.ly/3qFrbl5
    Deepak EduWorld :bit.ly/3zWWtIS
    Deepak Nehra : bit.ly/364SVGV
    Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
    Deepak EduWorld Playlist's:
    POWERPOINT COURSE ►
    • MS Power Point Tutoria...
    ADVANCED EXCEL ►
    goo.gl/A6LdZA
    ADVANCED EXCEL FORMULAS ►
    goo.gl/bbHYu2
    EXCEL TIPS & TRICKS ►
    goo.gl/wAj1jh
    MS WORD ►
    goo.gl/B4TeSA
    HTML5 & CSS3 ►
    goo.gl/2PFgs8
    COMPUTER TECHNICAL videos ►
    goo.gl/paZmpn
    AUTOMATIC INVOICE IN EXCEL ►
    goo.gl/dFhg54
    PHOTOSHOP TUTORIALS ►
    bit.ly/3kJyIBv
    Thanks for Watching
    Deepak EduWorld
    combine data from multiple sheets
    combine data from sheets into a single sheet
    merge data from multiple sheets
    consolidate data from multiple sheets
    combine data from multiple sheets into one sheet
    quickly combine data from multiple sheets
    consolidate multiple sheets into one in excel
    combine multiple excel sheets into one sheet
    consolidate multiple excel files into one
    Deepak EduWorld

Комментарии • 77

  • @mukundraverkar4009
    @mukundraverkar4009 8 месяцев назад +1

    All the videos are simplified way to learning 😊

  • @arunkumarsinghark3024
    @arunkumarsinghark3024 8 месяцев назад +3

    🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹
    सीखते रहो, सिखाते रहो l
    हमेशा हंसते मुस्कुराते रहो l कभी अपने लिए तो कभी अपनों के लिए l

  • @bijaykumarmishra7689
    @bijaykumarmishra7689 8 месяцев назад +2

    Informative and excellent

  • @Jamalhappy
    @Jamalhappy 8 месяцев назад +2

    Zabardast... Deepak bhai

  • @adnanahmad8574
    @adnanahmad8574 21 день назад

    superb brother ❤❤❤❤

  • @hariomjadon3999
    @hariomjadon3999 8 месяцев назад +1

    Thank you so much sir bahut accha topics hai ❤❤❤

  • @AnkitSharma-ym8db
    @AnkitSharma-ym8db 8 месяцев назад +1

    Awesome as always deepak❤

  • @sediqahmady3070
    @sediqahmady3070 4 месяца назад +1

    I love this technique...

  • @Parimal_Asodiya
    @Parimal_Asodiya 8 месяцев назад +1

    Excellent

  • @samarthraghani9357
    @samarthraghani9357 8 месяцев назад

    Bhai video bahut insightful hai. Thank you!
    Agr hum dusri copy sheet pr kisi ko share krk values me comvert mahi krte h or share krte hai to auto update hota rhe aisa koi option h kya

  • @AmnaIkram-mt4ey
    @AmnaIkram-mt4ey 8 месяцев назад +1

    Amazin sir but is this formula available in 2019 or 21 etc

  • @SAGAR-xc8oh
    @SAGAR-xc8oh 8 месяцев назад +1

    Thanku sir❤

  • @tumitshriwas
    @tumitshriwas 8 месяцев назад +2

    Vstack mst😊

  • @pradeepkumarkanhar3128
    @pradeepkumarkanhar3128 8 месяцев назад +1

    Thanks Sir

  • @parimalpatel4827
    @parimalpatel4827 8 месяцев назад +1

    Nice 💐

  • @pranjalbhalani
    @pranjalbhalani 8 месяцев назад +1

    Bro. Kya hum multiple workbook se data club kar sakte he kisi bhi tarike se?

  • @rajrana1534
    @rajrana1534 8 месяцев назад

    Awesome 😮😮😮

  • @abdullabs_2015
    @abdullabs_2015 8 месяцев назад +1

    I like it,

  • @1shahidramzan
    @1shahidramzan 8 месяцев назад +1

    v good dear

  • @rahulamesar5387
    @rahulamesar5387 5 месяцев назад

    Very useful sir

  • @SADBOY-ro4ob
    @SADBOY-ro4ob 8 месяцев назад +1

    Ok sir 😊

  • @SivaPrasad-vk6qb
    @SivaPrasad-vk6qb 8 месяцев назад

    For multiple workbooks can we use same formula?

  • @devrajcomputerinstitute2425
    @devrajcomputerinstitute2425 8 месяцев назад +1

    GST INVOICE REFOND PAR EK VIDEO BANAYE SIR

  • @LEARNWITHPASSIONGK
    @LEARNWITHPASSIONGK 4 месяца назад

    Kya vstack formula 2016 mein work karega

  • @jikptia3975
    @jikptia3975 8 месяцев назад +1

    Banking cash management kilya Excel ka ek VBA software kaise banaye

  • @AftabAli-rh8xo
    @AftabAli-rh8xo 8 месяцев назад

    Sir aap ka Microsoft word, PowerPoint, excel course lena hai

  • @gulamsabirpatangwala
    @gulamsabirpatangwala 8 месяцев назад

    Sir excel 7 ya 10 me kaam karega ye formula?

  • @MuhammadYousaf-yf2pg
    @MuhammadYousaf-yf2pg 6 месяцев назад

    Deepak can we do it in office 2013? Also can data in multiple excel files be linked/stacked like in individual sheet, please educate.

  • @khansahab8866
    @khansahab8866 7 месяцев назад +1

    Please guide ak cell ko edit ya change kr na ho to sari sheet change hojaye means k master sheet se edit kru to Meri all sheet me automatically wo paste hojaye

  • @RANjEETKUmAR-yc7fi
    @RANjEETKUmAR-yc7fi 8 месяцев назад +1

    Sir ab Google sheet ke upar banao

  • @abdullabs_2015
    @abdullabs_2015 8 месяцев назад +1

    I need to merge different files in one master file., like these sheets can you help me?

  • @muhammadfarhad2057
    @muhammadfarhad2057 8 месяцев назад +1

    Excellent Sir,
    Nice informative video.
    Farhad (Pakistan 🇵🇰)

  • @frgf64
    @frgf64 8 дней назад +1

    Ctrol+T press kia to table pe convert nahi ho ra ha hi. I am doing in google sheets.
    It appears web browser.

  • @gameingboybarun1168
    @gameingboybarun1168 8 месяцев назад +1

    Sir demo file de dijiye ❤

  • @harun5466
    @harun5466 4 месяца назад

    How to add dynamic chart in this master sheet which has vstack formula?

  • @paramjeet975singh3
    @paramjeet975singh3 8 месяцев назад

    deepak sir ap excel acche se karvate ho thanks sir, lakin excel par job 18-20k hi milti hai only....pls vba sql bi,....ispar bhi karvado taki salary acchi ho pure youtube par kisi ne bhi complete ni karvaya hai pls ap help karo tc

    • @PragSing-v6g
      @PragSing-v6g 8 месяцев назад

      Pna college ne sql krvaya ha

    • @nirajthakor9748
      @nirajthakor9748 8 месяцев назад

      ​@@PragSing-v6gDo u know any shortcut key to pop up FORMAT CELLS ???

  • @Gluconorm
    @Gluconorm 8 месяцев назад +1

    ❤❤❤

  • @tumitshriwas
    @tumitshriwas 8 месяцев назад +1

    Naya ms office download krana prega yar mera ab tk purana sd card format nai ho rha m windows download nai kar pa rha hu

  • @Moonchild4081-f8t
    @Moonchild4081-f8t 8 месяцев назад

    0:54 barcode ka inventory ka exel sheet banaiye sir .usame barcode item list bhi chahiye

  • @WINNING-ATTITUDE.
    @WINNING-ATTITUDE. 8 месяцев назад +1

    Aapka Course link

  • @virkumardevtale9671
    @virkumardevtale9671 8 месяцев назад

    How to compare 1st sheet data with 2nd sheet data and find the difference?

  • @koushikmandal8311
    @koushikmandal8311 4 месяца назад +1

    😊😊

  • @govindanc9346
    @govindanc9346 7 месяцев назад

    How to make a new table with the combined data. I am getting a spill error when I press Ctrl t to make a table

  • @tumitshriwas
    @tumitshriwas 8 месяцев назад +1

    Y pastespcl value jese pcs likhe h ctrl 1 ki mdd s vo kuy nai hota bano isp video jese 20 pcs formula laga diya aa b gaya yog ab isi ko dusre m paste krna ho to

  • @Uzikhan
    @Uzikhan 2 месяца назад

    what if tables are on single sheet

  • @Mumtaz022
    @Mumtaz022 5 месяцев назад +1

    Bhai ksi Achy se Office ka link tu send kar din ,,download kar longa

  • @abdullabs_2015
    @abdullabs_2015 8 месяцев назад

    How can we merge multiple data in different master file.

  • @sheebakhan1487
    @sheebakhan1487 7 месяцев назад

    sir practice sheet send kijiye mna plz

  • @sai-qj9ly
    @sai-qj9ly 8 месяцев назад

    👌👌👌👌👍❤

  • @mrg5970
    @mrg5970 8 месяцев назад +1

    Practice sheet kaha hai

  • @RAJESH198YADAV
    @RAJESH198YADAV 6 месяцев назад +1

    YE WALA FORMULA EXCEL 2016 ME Q NAHI AA RAHA HAI

  • @Official_Suraz
    @Official_Suraz 8 месяцев назад +1

    2019 main vstack nahi hai

  • @HayyatVoice
    @HayyatVoice 6 месяцев назад

    MS Excel 2021 mein nahi hu raha

  • @pubgmobile.kingofyoyo5458
    @pubgmobile.kingofyoyo5458 7 месяцев назад +1

    I Dont have Vstack in my excel what can i do😢

  • @excelexpert2987
    @excelexpert2987 3 месяца назад

    This formula is not working and showing error in office 365 as well

  • @TheSwamijee
    @TheSwamijee 6 месяцев назад

    vstack formula kaam nahi kar raha hai, ms office 2021 pe

  • @akashsiva5555
    @akashsiva5555 8 месяцев назад

    in my system filter comment not working kindly intimate the other options for transferring the data from one sheet to another

  • @shibuk8898
    @shibuk8898 Месяц назад +1

    Vstack nhi

  • @paramjeet975singh3
    @paramjeet975singh3 8 месяцев назад

    Excel 2016 mai kaise hoga sir

  • @umeshchandarana8415
    @umeshchandarana8415 8 месяцев назад

    How we do it for 12 months to Trs data into master sheet for payroll where all employees are not same in all months. New comes. Old goes during 12 months. How can we do it ? In your sheet data remains same.
    Please gude

  • @techdadagames7856
    @techdadagames7856 2 месяца назад

    ager sheet 100 ho to.. kaise karenge

  • @AmnaIkram-mt4ey
    @AmnaIkram-mt4ey 8 месяцев назад +1

    Sir excel version

  • @dharmendrakosta3342
    @dharmendrakosta3342 6 месяцев назад

    Vstac formula nahi he

  • @arvindsharma8654
    @arvindsharma8654 3 месяца назад

    Ye excel 2019 m to formula hi nahi lag raha h

  • @Ak_computer_Gyan
    @Ak_computer_Gyan 8 месяцев назад

    Excel 2021 me nahi hai ye formula sir 😢

    • @nirajthakor9748
      @nirajthakor9748 8 месяцев назад

      Kya aap koi solution de sakte ho that why is CTRL + 1 not working??

    • @Ak_computer_Gyan
      @Ak_computer_Gyan 8 месяцев назад +1

      @@nirajthakor9748 Dear I already Facing this problem I haven't any Solution for these kind of problems. 😔

    • @nirajthakor9748
      @nirajthakor9748 8 месяцев назад

      @@Ak_computer_Gyan Ohh i see.. Okay but if you find any solution don't forget to reply here 🙌

    • @nirajthakor9748
      @nirajthakor9748 8 месяцев назад

      @@Ak_computer_Gyan Today i got to know i don't know but i was trying with CTRL+1 and that 1 was from numeric keypad in keyboard of the right side but actually i should have used that "1" in the upper row.

  • @26krishnanjali
    @26krishnanjali 6 дней назад +1

    Kya muje aaapka mobile number mil sakta hai

  • @himanshubatrasuccessismine6578
    @himanshubatrasuccessismine6578 Месяц назад +1

    RUclipsr always welcome contact me

  • @muhammadatharkhurshid6468
    @muhammadatharkhurshid6468 Месяц назад

    Excellent

  • @shoaibmaseed3302
    @shoaibmaseed3302 6 месяцев назад

    ❤❤