Dynamic Connections to other Sheets via IMPORTRANGE Function

Поділитися
Вставка
  • Опубліковано 5 лис 2024

КОМЕНТАРІ • 82

  • @sandeepaswal8944
    @sandeepaswal8944 3 роки тому +7

    Sir Your way of explanation is great.❤ You are really inspiring for your teaching way. Hats off to you sir ji.❤

    • @Innozant
      @Innozant  3 роки тому

      Thanks Sandeep Ji..Happy Learning dear...God bless You ❤️

  • @abubackersiddique990
    @abubackersiddique990 3 роки тому

    Think you very much sir,
    I am your Excel fan from Saudi Arabia.
    Fantastic job God bless you.

    • @Innozant
      @Innozant  3 роки тому

      Thanks Abubacker Sahab ❤️

  • @RiddhiNayyar2.0
    @RiddhiNayyar2.0 Рік тому

    Sir you have explained this function very easily.

    • @Innozant
      @Innozant  Рік тому

      Thanks Monika..Keep Learning..And Keep exploring

  • @investmentknowledge9635
    @investmentknowledge9635 10 місяців тому

    End of each topics you always gives motivation factor to all viewer, its motivates us to learn further ❤🎉

  • @jayantabhattacharyya628
    @jayantabhattacharyya628 3 роки тому +1

    Dear Sir
    Excellent Google Sheet functions and it's uses. Nowadays Google Sheet is more useful than excel. Your superb teaching makes it more attractive.
    Thanks & Regards
    Jayanta Bhattacharyya

    • @Innozant
      @Innozant  3 роки тому

      Thanks Jayanta..Will upload complete series for Googlr sheets

  • @someonefrom2002
    @someonefrom2002 3 роки тому

    Sir I always watch your videos and you add a lot of value in my life.
    Love and huge respect to you sir ❤️❤️❤️

    • @Innozant
      @Innozant  3 роки тому +1

      Thanks Vivek ji..God bless You..Happy learning dear❤️

  • @brijeshshah574
    @brijeshshah574 Рік тому

    Simple and effective explanation.
    Me 5 brands take care kerta hun Har ek brand me abhi each 5-5 lines hai. Current year me muje 3 brands me 2-2 lines nayi add kerni hai. Ab jab me last year ka data dekhna chahta hun with current year to uske saath mene jo 3 brands me nayi line add ki hai wo bhi brand wise muje show kare. Nahi ki muje manually add kerna pade har ek brands k niche. Please help🙏 thanks in advance 😊

  • @Narendar.pathak
    @Narendar.pathak 3 роки тому

    Sikhane ki koi umar nahi hoti bahut hi damdar baat kahi aapne

    • @Innozant
      @Innozant  3 роки тому

      Thanks Narender ji..Happy learning ❤️

  • @sakhan1978
    @sakhan1978 10 місяців тому

    Can we add item stock qty automatically into finished goods stock or less from dispatched qty

  • @sameenarafiq1339
    @sameenarafiq1339 2 роки тому

    Really nice and informative.... Thank you so much for uploading ... Please keep it up

    • @Innozant
      @Innozant  2 роки тому

      Thanks Sameena for your valuable appreciation..❤️❤️

  • @eajazahmad5925
    @eajazahmad5925 2 роки тому

    Sir ji, you are fantabulous..

  • @manojkumarsingh3385
    @manojkumarsingh3385 3 роки тому

    Excellent video Sir
    🙏🏻🙏🏻🙏🏻

    • @Innozant
      @Innozant  3 роки тому

      Thanks Manoj Ji❤️

  • @createyour6681
    @createyour6681 3 роки тому +1

    Very great sir

  • @bhartendrashrivastava8031
    @bhartendrashrivastava8031 2 роки тому

    Sir you are awesome.
    I want to ask something, mere paas Excell file ki 52 sheet hain , in sabhi 52 sheet ki kisi ek particular row ke data ko kisi other Excell file mai lekar jana ho ya copy karni hain to uske liye shortcut ya koi tarika hain , jisse ye easily possible ho sake. If yes plz replay me .

  • @dipanshudas2343
    @dipanshudas2343 Рік тому

    Hi sir, how do we get different columns by using "importrange formula".
    and need more videos of DAX. i am big fan of you,lots of things i have learned from your videos.thanks for everything.

  • @devarshmehta6721
    @devarshmehta6721 2 роки тому

    which of your video can guide me how to pull cell value from other workbook to current worksheet cell using indirect reference written in some other cell of current worksheet? In excel.

  • @mamtasaini2615
    @mamtasaini2615 6 місяців тому

    Dear sir thanks for your guidance

  • @kishorpanara4191
    @kishorpanara4191 2 роки тому

    Awesome dear sir thank you sir

  • @balamira297
    @balamira297 2 роки тому

    Thanks sir, pls upload more videos on google sheets.

    • @Innozant
      @Innozant  2 роки тому

      Thanks Mira..Yes Complete series upload krenge Google sheets ke

  • @satishojha6240
    @satishojha6240 3 роки тому

    Fabulous video sir thanku🙏🙏🙏🙏🙏

    • @Innozant
      @Innozant  3 роки тому

      Thanks Satish Ji ❤️

  • @Srksmart-qm5dc
    @Srksmart-qm5dc 3 роки тому

    Good it's really appreciating

  • @subratadatta18
    @subratadatta18 Рік тому

    Sir, GOOGLEFINANCE par share market ke data auto import karne ke liye aur auto update karne ke video banaye . It will be very helpful for market watchers.

  • @garimamishra5731
    @garimamishra5731 4 місяці тому

    Thank you 🙏

  • @RahulMahaur-c6j
    @RahulMahaur-c6j Рік тому

    Agar cell me color ho rha ho to wo bhi import ho skta hai kya uske sath dusri sheet pe?

  • @sohabaig3047
    @sohabaig3047 2 роки тому

    Sir I have a one doubt please make 1vedio on that if we have multiple sheets and we have to make 1sheet like if we change in multiple sheets that reflects in 1home sheet

  • @MdAman-rj3nr
    @MdAman-rj3nr Рік тому

    How to highlight a All Upper case data by using conditional formatting in Excel.

  • @hsgusain2054
    @hsgusain2054 3 роки тому

    Superb Sir... Power BI ki class chal Rahi recent me koi

    • @Innozant
      @Innozant  3 роки тому

      Haan .28th Nov se start hone ja rha hai join kar lena Sunday only class hai @11:30am

    • @hsgusain2054
      @hsgusain2054 3 роки тому

      Ok Sir

  • @vijaydagar8519
    @vijaydagar8519 Рік тому

    How power query function work if all excel files saved on cloud server.

  • @paramjeet975singh3
    @paramjeet975singh3 3 роки тому

    Sir interview Mai wfm ke bhi question puchte hai kya??

    • @Innozant
      @Innozant  3 роки тому

      Haan kuch specific organization me puche jaate hain..

  • @kishansaria8179
    @kishansaria8179 2 місяці тому

    How to use importrange from say Sheet5 and not the first sheet

  • @yadavofficelchanal55
    @yadavofficelchanal55 3 роки тому +1

    Good

  • @ranjitray968
    @ranjitray968 2 роки тому

    Sir Google sheets ka video uploaded ki jiye pls

  • @vijaydagar8519
    @vijaydagar8519 Рік тому

    How to import & Marge more then 1 sheets data "same format files"

  • @KOUSHIKDEY-ml7xo
    @KOUSHIKDEY-ml7xo 6 місяців тому

    Circular dependency detected. To resolve with iterative calculation, see File > Settings.-SIR HOW TO I SOLV THIS ERROR? PLEASE HELP ME

  • @rajendrakumarjena7524
    @rajendrakumarjena7524 2 роки тому

    Sir please Google sheet m query formula sikha dijie

  • @SurenderRawat-pv4us
    @SurenderRawat-pv4us 6 місяців тому

    Sir ji, main ne Sheet "A" se import range kar ke data Sheet "B" me transfer kar diya, to kya me ab Sheet "B" me kuch change karna chata hu kya wo ho skta ha

  • @rovar7104
    @rovar7104 2 роки тому

    Sir can I join MIS Executive role as a fresher with the help of power bi tool and advance excel in 21 age 🙏🏻🌻❤❤ I am not 21 but I will be in 21 in this December 1

  • @pratikkumar391
    @pratikkumar391 3 роки тому

    Sir, mai excel VBA ka course karna chahta hu. Aap mujhe VBA sikhne ka liye kuch idea de sakte.

    • @Innozant
      @Innozant  3 роки тому

      Aap Live class training join kar sakte hain for VBA

  • @sonuadhikari4145
    @sonuadhikari4145 3 роки тому

    Sir ap class bhi dete ho

    • @Innozant
      @Innozant  3 роки тому

      Yes Sonu..Our Live Classes Are Running,,You may join the same

  • @pssolutions1422
    @pssolutions1422 Рік тому

    Sir import range main ek error aajata hai import range internal error isko kese slove kare

  • @tikapursahakari
    @tikapursahakari Рік тому

    sir namaste importrange 3 spreadsheets se jayada q nahi le raha hai plz help me

  • @sawaimalhi8439
    @sawaimalhi8439 3 роки тому

    Jai ho first comment

  • @computerknowledgeno1
    @computerknowledgeno1 Рік тому

    google sheet m conditional formatting ki vedio nhi hai

    • @Innozant
      @Innozant  Рік тому

      Excel series se cover kariye

  • @Ziab-h7f
    @Ziab-h7f Місяць тому

    "Argument Must be a range"
    Importrange ko sumifs k sath use krne pr ye error aa raha h sir google sheet me

  • @avinashsuccess
    @avinashsuccess 2 роки тому

    Sir hmko bahut prablem ho raha hai query function ka use bataye Google sheet par

    • @Innozant
      @Innozant  2 роки тому

      Aane wala hai kuch time me dear

    • @avinashsuccess
      @avinashsuccess 2 роки тому

      @@Innozant thanks you sir I am waiting

  • @dhakafady774
    @dhakafady774 Рік тому

    wow

  • @durgeshrai8938
    @durgeshrai8938 3 роки тому

    🙏🙏🙏🙏

  • @durgeshrai8938
    @durgeshrai8938 3 роки тому

    Sir power bi download kiya but framework required krke msge aa rha h pls need help
    Windows 10 64bit

  • @jetixstar9070
    @jetixstar9070 3 роки тому +1

    i am irfan mujhe bhi excel aata h

  • @jetixstar9070
    @jetixstar9070 3 роки тому +1

    first view

  • @dhakafady774
    @dhakafady774 Рік тому

    wow

  • @gauravbhatia7987
    @gauravbhatia7987 2 роки тому

    🙏🙏🙏🙏🙏

  • @dhakafady774
    @dhakafady774 Рік тому

    wow