+ Reply to Thread
Results 1 to 5 of 5

Extract specific cells from multiple excel files in same folder to new summary file

  1. #1
    Registered User
    Join Date
    12-01-2014
    Location
    Brisbane
    MS-Off Ver
    2013
    Posts
    2

    Extract specific cells from multiple excel files in same folder to new summary file

    I invoice using excel and have a folder with hundreds of xls & xlsm files. I want to extract 4 specific fields ; C8;AK4; AK7 & AL11 from each file into a table a new file with NAME, DATE, INVOICE NO & AMOUNT as the headings. I'm not experienced at VBA.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Extract specific cells from multiple excel files in same folder to new summary file

    So I created a workbook with an UPDATE tab, and a DATA tab. The Update has the button to run the macro, and the DATA tab houses the column Headers and is where the data is brought in.



    I am assuming the source sheet is Sheet1, otherwise you need to change it below.



    Please Login or Register  to view this content.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Extract specific cells from multiple excel files in same folder to new summary file

    I tried attaching the workbook, but it didnt work. I woner if the 2.5MB size is a problem.

    Either way, just create a DATA dab and include column headers in A1:D1

  4. #4
    Registered User
    Join Date
    12-01-2014
    Location
    Brisbane
    MS-Off Ver
    2013
    Posts
    2

    Re: Extract specific cells from multiple excel files in same folder to new summary file

    Thanks. Sorted it out. Works great. Much appreciated. Can you tell me how to create the update tab as it would save opening vba & 'f5'ing it?

  5. #5
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Extract specific cells from multiple excel files in same folder to new summary file

    Google is your friend.

    I'm on my phone or I'd send you a link. Look up how to add macro button (with the developer tab). You add the button then link it to the macro. You can have the button on the DATA tab if you want, it doesnt matter.

+ 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. Replies: 7
    Last Post: 09-29-2014, 09:24 AM
  2. Merging cells from multiple files in a folder into one file
    By Alteregoist in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2013, 04:26 AM
  3. [SOLVED] How to Extract Data from Multiple Files in Same Folder and Copy Data to One File
    By champ052005 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-10-2013, 01:25 PM
  4. Extract specific column data from specific sheet from multiple files in a folder
    By piggyfox in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-31-2013, 11:51 AM
  5. Replies: 1
    Last Post: 05-24-2007, 07:28 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