+ Reply to Thread
Results 1 to 1 of 1

Extract Data from Multiple Workbooks and insert in New Sheet

  1. #1
    Registered User
    Join Date
    08-13-2014
    Location
    London
    MS-Off Ver
    2011 (365) Mac
    Posts
    5

    Extract Data from Multiple Workbooks and insert in New Sheet

    Hi Guys,

    Firstly let me apologise in advance for making an outright request for help, rather than at least offering something to work from, but I have never used VBA or Macros before and actually don't even know if they are different things or in fact a different way of referring to the same thing. However I am familiar with functions etc and don't believe that what I need can be achieved using a function. I am hoping that you might be able to shed some light on whether its possible with VBA and if so... offer a start point for where I might begin...

    The Challenge.

    I have a few hundred data files .gpx which I have converted to .xls files. Each file contains a lot of surplus data which is not needed. I need to extract the data from each file, which is found in D46 and E52 and add this data to a new worksheet; A2 B2, then for the next file extract the data from the same cells, but add it it to the next row of my sheet A3 B3.

    Question.

    Is it possible to create a macro that will perform this for all closed files in a single folder? If not is there a work around that might achieve the same goal coming at it from a different angle.

    Here's hoping
    S
    Last edited by LondonSmudge; 10-01-2014 at 05:07 AM. Reason: Typo

+ 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. VBA to extract sheet in multiple closed workbooks to a sing sheet on new workbook (HELP!)
    By The1theycallp in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-12-2014, 08:19 AM
  2. Macro To Extract Data From Multiple Workbooks To A Single Sheet - Excel
    By Joshdm0716 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2013, 12:12 PM
  3. Macro to extract data from multiple workbooks, specific sheet, specific cells
    By crissandraauree in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2012, 03:54 PM
  4. Extract Data from Multiple Workbooks to One Sheet
    By jketcher in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-01-2012, 04:41 PM
  5. Macro to extract data from multiple workbooks to a single sheet
    By Phil73 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-23-2011, 05:15 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