PDA

View Full Version : Date -Format problems



dresen
12-15-2007, 03:10 AM
I have a large data sample and i need to extract data between to specific dates. Can't figure out how to make it work?

Hope someone can help me :-)

Bob Phillips
12-15-2007, 03:21 AM
More detail required. What does extract mean? List them, sum them, count or what?

dresen
12-15-2007, 03:31 AM
Oh, sorry.
Lets say I have lots of data. One column containing a date going way back in time. . I want to enter a startdate and an enddate in 2 inputboxes and then "pull" out the data inbetween these dates

dresen
12-15-2007, 03:40 AM
With pull out I mean just to "range variable" or sheet.

XLGibbs
12-15-2007, 02:02 PM
Take a look at using External Data > MS Query. YOu can actually query your one sheet and return the data elsewhere. YOu would add the date criteria in the query design (and there are options to pass the dates as parameters, or be prompted for them when you query)

You can query your exel file from within itself.

YOu can also look at using auto filter followed by Go To > Special Cells> visible cells only and copying the data to another sheet.