+ Reply to Thread
Results 1 to 2 of 2

Import of data based on start and end time

  1. #1
    Registered User
    Join Date
    12-15-2011
    Location
    SWEDEN
    MS-Off Ver
    Excel 22007
    Posts
    7

    Red face Import of data based on start and end time

    Ok people, let your excel knowledge hit me like a tidal wave

    I have an excel 2007 workbook filled with processdata (date as column, Id as rows). I want to automaticly present the data in charts. But only data between a start and end time should pop up in the charts. To make it a bit worse most the data be "Normalised" before (probably divided with the mean for the whole time period).

    The root source most stay intact so I guess I need to set up some type of automatic import connected to a start/ end button (Ok to use start end cell). Could some one please help me

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,681

    Re: Import of data based on start and end time

    you probably don't need a macro to do this, just formulas - see the attached for an example
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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