Acessing data between two dates
Acessing data between two dates
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Acessing data between two dates

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Want to be able to access data from a history file between two specified dates.
    ie. Have data from 2/3/02 to 28/3/02(history file).
    Need to pull data between the dates 7/3/02 to 14/3/02.

    Any ideas would be of great help!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    There's probably many ways of doing it, but a couple of the easiest would be to either create a pivot table of your data and exclude any dates outside those you require; or use a custom autofilter to filter out data outside your interval and copy and paste to a new sheet.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com