+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Data Between Dates

  1. #1
    Registered User
    Join Date
    11-24-2011
    Location
    Liverpool
    MS-Off Ver
    Excel 2007
    Posts
    7

    Question Data Between Dates

    Right,

    I am totally new to Excel - However I am trying to to grab data between dates.

    I have data grabbing from another sheet thats a big list of dates, but I want the user to be able to select the dates in a drop down box and for it to only show data between and equal to them dates.

    on top of that, I want to be able to include some sort of button or cell that grabs the data and includes other text wrapping around it.

    E.G.

    PHP Code: 
    elseif formatdatetime(now,2) = "21/11/2011" Then            
                
                    Response
    .Write("[COLOR="seagreen"]MESSAGE FROM CORROSPONDING DATE[/COLOR]")            
                
    elseif 
    formatdatetime(now,2) = "22/11/2011" Then            
                
                    Response
    .Write("[COLOR="PaleGreen"][COLOR="SeaGreen"]MESSAGE FROM CORROSPONDING DATE[/COLOR][/COLOR]"
    If it is possible (I am not sure, as I am totally new to excel) to make these queries have varibles, i.e. grabbing the range it searches from cell boxes. Just that if I end up updating it, I don't want to update code I barely understand and updating some cells with values would be much easier.

    Any help on this would be greatly appreciated as I feel I have gone as far as I can with the basic knowledge I have (just from reading tutorials and articles).

    I have attached a sample document.

    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-24-2011
    Location
    Liverpool
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Data Between Dates

    Any help will be appreciated

  3. #3
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Data Between Dates

    Have you looked into pivot tables? http://peltiertech.com/Excel/Pivots/ That would give you an easy way to select which dates to show. If you want just two dropdowns for beginning and ending date, that will take a separate table. It's possible, but I think a pivot table might be cleaner and would certainly give more options. As another option you could just highlight the table and apply a filter. With the filter, you can select which dates to show or hide. It's not as powerful as a pivot table, but if this is all you need, it should work well for you.

    As for your other request, I'm not sure how to get that or exactly how your example ties into your workbook. It looks like it will take VBA to accomplish that part, and for that, I'm sorry, but I've never delved too deeply into that side of Excel. Most of the other gurus and mods on here though speak it fluently. I'm sure one of them will be able to help.
    Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.

    If you like a post, please rate it with the scales icon (top right).
    If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.

  4. #4
    Registered User
    Join Date
    11-24-2011
    Location
    Liverpool
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Data Between Dates

    Thanks for taking the time to respond, I shall have a read and see if I can some how integrate into to my document.

    Thanks

+ 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