Return Sheet Name in Cell - Excel Formula

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

КОМЕНТАРІ • 17

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

    Thank you so much for walking through this step by step - excellent training!

  • @davidlittle9575
    @davidlittle9575 2 роки тому +5

    How do I get it to just work per sheet? Right now when I do that to a bunch of sheets they all return the same value.

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

    man ! you just saved me hours of work, i have been researching like 40 min, something about indirect function, this is way clever!

  • @crystalpylatuik6711
    @crystalpylatuik6711 2 роки тому +2

    Your tutorial is wonderful and straightforward. thank you! However, I am now having each sheet reference to the other sheet name, not the sheet name I am on without resetting formula. Is there a fix for this?

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

    Excellent information formula. Thank you very much Chester.

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

    thank for your sharing

  • @salemnj1
    @salemnj1 2 роки тому +1

    Is there a way to do this in the online version of Excel? Just gives me an error if I don't use the desktop version.

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

    great help Chester, subscribed:)

    • @MuhammadAli_1807
      @MuhammadAli_1807 3 роки тому +2

      Hey Chester, the function works well but when you have multiple tabs or sheets open the formula reflects the result where the cursor is, any trick to lock the formula for a each separate tab? Appreciate the help

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

    Hi, thanks for your video.
    I was wondering if you have any idea how to do the following :
    I would like to return in a cell from the Tab 1 the second tab name.
    In your case for example in A1 (tab ABC LTD) I would like the cell to return the second tab name here : XYZ LTD.
    I can't find any solution online.
    Thank you !

  • @user-gk3lu1gg9t
    @user-gk3lu1gg9t 3 роки тому +5

    How would I return the name of the "XYZ LTD" sheet on the "ABC LTD" sheet?

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

    What about pulling the sheet name into a cell from a different tab/sheet? So I have a primary sheet where I'm consolidating all the sheet names in the same workbook

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

    THIS IS GOOD IF I HAVE JUST ONE SHEET. FOR MULTILE SHEETS IT FILLS IN THE VALUE OF THE SHEET I JUST LOOKED UP ON ALL THE SHEETS. ADVICE?

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

    This used to work for me but now it is returning the whole file name and not picking up just the sheet name after the ]. I'm not aware I changed anything