+ Reply to Thread
Results 1 to 2 of 2

Google Sheet dashboard

  1. #1
    Registered User
    Join Date
    10-14-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    98

    Google Sheet dashboard

    Hello,

    I am trying to create a google sheet dashboard for my manager that summarizes all the outstanding tasks he has.

    In order to do this, I am retrieving data from different google sheets and using different formulas to make it happen.

    1. Is it possible to use a formula that shows the name of the sheet?
    2. I am familiar with the formula "import range" but is it possible to select which tab you want?

    Thank you for your help

  2. #2
    Registered User
    Join Date
    12-24-2013
    Location
    U.S.
    MS-Off Ver
    2010
    Posts
    2

    Re: Google Sheet dashboard

    Since this is an Excel forum, I'm assuming you're using Excel and not Google sheets.

    After you save your file (it will not work if your file isn't saved), enter this formula in any cell:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    https://www.extendoffice.com/documen...-tab-name.html
    https://sourceforge.net/u/jerome-smith01/profile/

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Route Calculator - Google Maps Api 22 Minutes quicker than Actual Google Website
    By lookingforhelp1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-06-2015, 01:23 PM
  2. Replies: 9
    Last Post: 11-07-2014, 07:10 AM
  3. Replies: 0
    Last Post: 06-26-2014, 11:31 AM
  4. Replies: 3
    Last Post: 12-22-2011, 10:57 AM

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