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 :-)
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 :-)
More detail required. What does extract mean? List them, sum them, count or what?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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
With pull out I mean just to "range variable" or sheet.
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.
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
Posting Permissions
Reply With Quote
