Results 1 to 3 of 3

Extract Data from Multiple Closed Excel Files

Threaded View

  1. 07-28-2014, 11:39 PM #1
    Gittelman
    Gittelman is offline
    Registered User
    Join Date
    07-02-2014
    Location
    Miami, Florida
    MS-Off Ver
    Microsoft Excel for Mac 2011 Version 14.4.1
    Posts
    8

    Extract Data from Multiple Closed Excel Files

    Hi All,

    The below article explains exactly what I am trying to do but the formula in step 5 doesn't seem to work. I keep getting an #REF! Error.
    http://www.ashishmathur.com/tag/morefunc/

    I am not sure if maybe I'm typing in the quotations wrong or if the formula doesn't actually work.

    Someone please verify that the formula works.
    Thanks for the help!
    Last edited by Gittelman; 07-29-2014 at 12:11 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract Data from Multiple Cells of Closed Excel Files and Include Formulas
    By Gittelman in forum Excel General
    Replies: 0
    Last Post: 07-28-2014, 10:19 PM
  2. Vba to extract data from multiple closed workbooks
    By The1theycallp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2013, 07:49 AM
  3. Extract Data From Multiple Excel Files -> One File
    By ozzabozza in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-16-2013, 10:20 AM
  4. [SOLVED] Extract Data From Multiple Excel Files -> One File
    By Michael via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-24-2012, 01:02 PM
  5. GetValue to extract data from closed files
    By John James in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2006, 06:19 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1