+ Reply to Thread
Results 1 to 2 of 2

Dynamic Worksheet Reference without using INDIRECT

  1. #1
    Registered User
    Join Date
    06-12-2019
    Location
    houston, tx
    MS-Off Ver
    1903
    Posts
    4

    Dynamic Worksheet Reference without using INDIRECT

    I was curious if there is a way to dynamically reference a worksheet in a different excel file without using the INDIRECT function. At this point I am using INDIRECT but it requires that the worksheet I am referencing be opened so I am trying to see if there is a way to dynamically reference without having the sheet being referenced open. Thanks for the help!

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,247

    Re: Dynamic Worksheet Reference without using INDIRECT

    To access closed wbks, except for SUMPRODUCT, you will need VBA one way or another or a 3D reference depending on your formula/function
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

+ 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. [SOLVED] Dynamic indirect reference with named lists
    By sabiza in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-25-2020, 05:34 AM
  2. Dynamic List Using Indirect Reference in VBA
    By KENZO-TESLA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2020, 06:43 AM
  3. SumIFS with dynamic sheet reference not using INDIRECT
    By MichaelLuthi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-19-2019, 11:55 PM
  4. How to reference a dynamic tab in excel (maybe indirect, but not sure)
    By GABY1234 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-13-2019, 05:17 AM
  5. [SOLVED] INDEX MATCH with dynamic reference using INDIRECT
    By Avaritia in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-11-2019, 11:09 PM
  6. VBA Dynamic Range - An Indirect Cell Reference
    By ExcelHelp2013 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2013, 11:08 AM
  7. [SOLVED] Dynamic VLOOKUP wit INDIRECT reference
    By supern0va in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-29-2012, 11:44 AM

Tags for this Thread

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