+ Reply to Thread
Results 1 to 2 of 2

How to open another excel workbook to a specific sheet but take the sheet number from a1

  1. #1
    Forum Contributor sspreyer's Avatar
    Join Date
    07-05-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    178

    How to open another excel workbook to a specific sheet but take the sheet number from a1

    Hi,
    all

    how to hyperlink to another workbook to a specific sheet but using a1 to define what sheet to goto.
    Please Login or Register  to view this content.
    Here's what have tried but im out of my depth
    Please Login or Register  to view this content.
    thanks in advance

    shane

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    20,897

    Re: How to open another excel workbook to a specific sheet but take the sheet number from

    What do you have in A1? Is it the full sheet name? If so you can try this:

    =HYPERLINK("[C:\Users\osknows\Desktop\Book2.xlsm]"&A1&"!B4","CLICK HERE")

    Pete

+ 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. Using a cell reference to open a specific sheet within a closed workbook
    By heliwiggy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2014, 12:15 PM
  2. Replies: 3
    Last Post: 08-27-2013, 09:48 PM
  3. Master Sheet to Open Specific Sheet from a Separate Workbook
    By jennyaccord in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2011, 10:40 AM
  4. How do I open a workbook in a specific sheet
    By PetterSn in forum Excel General
    Replies: 3
    Last Post: 01-12-2006, 02:50 AM
  5. [SOLVED] Open Specific Sheet in Workbook
    By jhahes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2005, 04:26 PM

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