+ Reply to Thread
Results 1 to 3 of 3

Pulling Data from Multiple Spread Sheets

  1. #1
    Registered User
    Join Date
    10-05-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Pulling Data from Multiple Spread Sheets

    Hello community! Thank you in advance to anyone who can help crack this one:

    I receive daily reports like the attached via email. The data I would like to pull from it is:
    1. The numbers in column K. The total each day varies.
    2. The revenue amounts in column "S" that correspond to the numbers in "K"
    3. The number in cell "J6" that comes after 'park attendance='
    4. The date in the cell just bellow the attendance (also the name of each file sent)

    I can set up a database in either Access or mySQL to receive the data... I just don't know how to get the info to move from one to the other.
    I have asked that the data be sent in .csv rather than excel, but that is not an option. I may have to do that much manually unless anyone has a better idea.
    I have a backlog of these sheets of 3 months and a new one showing up each day.

    Thanks,
    Sawyer
    Attached Files Attached Files

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Pulling Data from Multiple Spread Sheets

    Would it be possible for you to add a sheet to your attached workbook showing what your desired results looks like? We can probably develop a macro to do this automatically.
    Also, how stable is the structure of those file? Are they all structured the same? Always?
    Last edited by p24leclerc; 10-06-2011 at 10:25 PM.

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Pulling Data from Multiple Spread Sheets

    Hi sawyer1

    Don't know what output format you're looking for. Run "Extract_Data"...results are shown on Sheet 2.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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