Closed Thread
Results 1 to 3 of 3

Rework of an INDIRECT.EXT function

  1. #1
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Rework of an INDIRECT.EXT function

    A weekly file is created with a scoring method for colleagues
    I then had a monthly master file that by referencing the months “week numbers” the data from the required 4 or 5 workbooks could be combined for a months’ total (and a copy saved called that month)
    This worked perfectly with Excel 2007 and INDIRECT.EXT function from MOREFUNC
    Having had to move to excel 2016 this is the one major loss have I have encountered

    Can anyone suggest an alternative method

    Formula was

    Please Login or Register  to view this content.

    C3 = p:\my Documents\driver database\driver assessment 2016\ (Path)
    D3 = DRIVER ASSESSMENT WK_27.xlsm ‘This is the variable’ (Workbook Name)
    I3 = SCALESHEET (Worksheet Name)
    Scale = named range
    Drivername = named range
    Score = named range
    Title = named range

    Any help appreciated
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Rework of an INDIRECT.EXT function

    This is a duplicate and an answer has already been provided at the first page, Forum Moderators: please close this thread.

    other thread address:
    http://www.excelforum.com/excel-gene...-function.html
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Rework of an INDIRECT.EXT function

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Rework of an INDIRECT.EXT function
    By nigelog in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-20-2023, 04:57 PM
  2. ReWork of and Old question
    By excelneub in forum Excel General
    Replies: 2
    Last Post: 06-02-2016, 01:34 PM
  3. [SOLVED] INDIRECT Function with multiple sheets - SUMIF, INDIRECT & MATCH
    By DJDRU in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2014, 08:42 AM
  4. [SOLVED] Merge cells with same value, old code needs rework.
    By johansoder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2014, 09:14 AM
  5. [SOLVED] Rework in vba code to refresh sum value.
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-15-2013, 02:54 AM
  6. how do i rework the sequence of data
    By ranjan in forum Excel General
    Replies: 3
    Last Post: 05-08-2007, 09:11 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