+ Reply to Thread
Results 1 to 1 of 1

need to have the tab list auto-refreshed after adding or deleting tabs

  1. #1
    all4excel
    Guest

    need to have the tab list auto-refreshed after adding or deleting tabs

    have got what i wanted for a very long time just one more thing though
    when i change Rename the Sheet 2 ,Sheet 3 it immediately does not reflect the change and if i change the name of the Sheet1 it does not reflect it all,Is there a way that it can immediately get refreshed and i wont to exclude the Sheet1 which would be the Summary Sheet.
    For eg :-Lets say i have three sheets Total \ A \ B ....
    Now i want to exclude the Sheet with name Total or whichever i select so is it possible to do that way , hope not asking too much and also kindly attach the file i would be reallly very grateful...

    The code is very simple (one-liner) but i think its VBA ,Unfortunately i dont understand VBA at all and also Macros do u know any website where i can atleast getthe BAsics for the same...

  2. #2
    all4excel
    Guest
    Try a formula version...

    Select cell B2

    Then go to the menu bar select

    Insert > Name > Define

    Name: Sheets

    Refers to:

    =SUBSTITUTE(GET.WORKBOOK(1),"["&GET.WORKBOOK(16)&"]","")

    Click Ok

    Then input formula in cell B2 and copy down.

    =INDEX(Sheets,ROWS($B$2:$B2))

    everything works fantasticexcept tfor the fact that it does not get updated immediately when the tabs are added/deleted..
    So please anything more please if u cud attach a file with expalnation..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1