Extracting information from a database

P

paulrm906

I have just set up a database with the date in the first colmn and then
about 50 colmns full of data and of cause a heading, and I would like to
have a new page setup with all this information in colmn A. Then for
example in cell B1 will be a date 15-June 05 and in cell C1 15-Oct 05
and I need a formula to extract the information from database starting
from the 1st (B1) date and ending with 2nd (C1) date.

Thankyou in advance Paul Maynard.
 
P

paulrm906

Debra said:
You can use an Advanced Filter to extract the data. There are
instructions here:

http://www.contextures.com/xladvfilter01.html#ExtractWs

And an example of date criteria at the bottom of the page:

http://www.contextures.com/xladvfilter01.html#Criteria
Click to expand...

Thanks Debra

I will give a go tomorrow but I still need to find if there is a
formula to extract data from one date to another date has my boss does
not know a lot about excel. I would like it if he could just enter the
dates from and to and the information appears just like magic.

Thanks

Paul Maynard
 
P

paulrm906

Thanks Max

I don't know it works but it worked for but admit it did take me a few
hours. the only draw back is that it really does slow my computer down
at work and takes for ever to update it self however I will be trying
this at home soon to see if it actually works quicker there.

Thanks again

Paul Maynard:)
 
P

paulrm906

Thanks again Max

I am back in thye office tomorrow morning and if i have time i will
test your theory on manual update.

Paul
 
Top