Results 1 to 3 of 3

Preventing off retrieve data multiple times

Threaded View

  1. #1
    Registered User
    Join Date
    03-06-2014
    Location
    Holland
    MS-Off Ver
    Excel 2007
    Posts
    6

    Preventing off retrieve data multiple times

    Hello everybody,

    Current program i use follows these steps:

    -Empty cells

    -Remove comments

    - Fill Headers

    - Retrieve Data (From the path Results (a subdirectory))

    - Sort on date and time (column D)

    My Problem: The programma now used retrieves every file in the subdirectory again and again.
    If it has like 100-200 files it takes a very long time.

    Is it possible to make a function for this that only retrieves files when the filename is not imported already? (Title is in the D Column)

    Wish: a function that retrieves only the required data and skips measuring data thats already there.
    Last edited by ramborabs; 03-06-2014 at 06:34 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pull retrieve data from multiple workbooks
    By Fett2oo5 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-08-2013, 07:00 PM
  2. How to retrieve data for multiple stocks?
    By MarginofBuffett in forum Excel General
    Replies: 1
    Last Post: 10-22-2011, 07:44 PM
  3. Replies: 1
    Last Post: 07-26-2011, 02:58 AM
  4. [SOLVED] How can I retrieve data from the same cell, from multiple sheets?
    By Alex Costache in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-01-2006, 07:00 AM
  5. [SOLVED] Retrieve data from multiple Excel sessions
    By JessK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2006, 04:45 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