+ Reply to Thread
Results 1 to 8 of 8

Basic excel user, first time on a forum with question about date data extraction

  1. #1
    Registered User
    Join Date
    05-11-2015
    Location
    Bowral, NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Basic excel user, first time on a forum with question about date data extraction

    Hi everyone

    This is the first time I have posted on a forum regarding excel as I haven't really had to use it, save for some basic school and university macro work which I now cannot remember a whole lot of.

    I am dealing with a 38 identical spreadsheets which are updated every few days manually, and some by a code. Each Spreadsheet is a fixed style that was purchased off a gas analysis company, and displays data from gas samples taken in an underground coal mine. The data is dropped into excel via a macro that asks for the matching file, a weird reader file that a gas analysis machine spits out (hundreds of them, one per gas sample).

    I am creating a totally seperate spreadsheet that I will ideally, be able to type into a date button a date range, say, 7 days or so, and then have data for the required gas values (Nitrogen, oxygen, Carbon Dioxide, Methane, Carbon Monoxide Raw and Carbon Monoxide Air Free) values pop up from each of the spreadsheets.

    For example, spreadsheet MG104 B32ct. That is a codename for one of the underground roadways, and the gas sampling point there.
    There are 37 similar code names. For this roadway, the spreadsheet contains a varying amount of gas data values, and after it is manually loaded again every few days, the new spreadsheet I am trying to build will display the above gasses for that week, for all 38 roadway gas points.

    I have uploaded a copy of the original spreadsheet and example of some data that it holds. I chose MG104 B32ct.
    I have then uploaded a copy of a basic idea of what I want to achieve... with the simpler spreadsheet showing data for a recent week that I just went through and manually inputted the data for a report.

    I realise this is a huge first post and probably quite technical, but I just feel it is relatively easy if you know how! A date range search, then spitting the data range range data for that row back into the newer spreadsheet.... sounds easier than it is im sure haha!

    Even a starting point would be of much help..

    Thanks a lot community!

    Mitch,

    Australia
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-11-2015
    Location
    Bowral, NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Basic excel user, first time on a forum with question about date data extraction

    I am having trouble uploading the worksheet with the gas data in it that we usually use, it is 1.78MB. Does anyone know a way to upload a more complex file?

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Basic excel user, first time on a forum with question about date data extraction

    G'day cobber

    Did you upload the correct file? I see a single table with some data in it, but no sample output?

    also...
    I am dealing with a 38 identical spreadsheets
    do you mean 38 different files, or 38 different sheets within 1 file?

    edit: 1.78 mb should not be a problem, the limit is 1000 mb. Is it an excel file?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    05-11-2015
    Location
    Bowral, NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Basic excel user, first time on a forum with question about date data extraction

    Hi FDibbins, thanks for that super fast reply!
    Yes the very basic table sheet is somewhat of a final product of what I am aiming for. The values actually correspond to the varying different sheets, I have just manually inputted them (typed them in) as I am not sure how to get an automated version - the reason for my query to you excel gurus!

    Yes there are 38 seperate spreadsheets... Each of them identical however. Each one has the same number of 'sheets' below, each are the same template that was supplied by the gas analysis mob a few years ago for the gas analysis machine.

    Yes I believe it is an excel file, as it opens in excel like other spreadsheets, but i think there is a fair bit of macro stuff happening in the back there. Still, that seems massive. I will have another look.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Basic excel user, first time on a forum with question about date data extraction

    OK, if you uploaded a sample of what you want, we would need to see a sample of what you have (presumably the 1 you are having a problem with)

  6. #6
    Registered User
    Join Date
    05-11-2015
    Location
    Bowral, NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Basic excel user, first time on a forum with question about date data extraction

    Ok, here is one of the files. This particular sheet shows the data for MG101 4ct seal, which is one of the roadway gas points.

    As you can see, there is various results (on the results tab) that shows H2, O2, etc.... and the entry is dated (in our australian date style, haha!)
    So the idea would be to have the 'completed' sheet, show the data that is in the SMARTMATE sheet when you type in the date... if you get what I mean!
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    05-11-2015
    Location
    Bowral, NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Basic excel user, first time on a forum with question about date data extraction

    Just wondering if anyone was able to cast an eye over the spreadsheets and perhaps give out a few pointers, thanks everyone

  8. #8
    Valued Forum Contributor
    Join Date
    04-26-2015
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    502

    Re: Basic excel user, first time on a forum with question about date data extraction

    Quote Originally Posted by Mitch199 View Post
    Just wondering if anyone was able to cast an eye over the spreadsheets and perhaps give out a few pointers, thanks everyone
    I tried taking a look but you have sheet protection on.

+ 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. Hello from a 1st time Forum user
    By Victoria G in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-08-2015, 08:42 AM
  2. New to this forum but a long time Excel user
    By JJ-Texas in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 04-07-2013, 06:36 AM
  3. Replies: 1
    Last Post: 11-07-2012, 08:00 PM
  4. First time forum user
    By Ken L. in forum Excel General
    Replies: 6
    Last Post: 03-21-2008, 12:37 PM
  5. Basic question from infrequent user
    By nsutton1981 in forum Excel General
    Replies: 2
    Last Post: 06-28-2007, 08:55 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