Hi all

I have an excel database with laboratory results stored in it. The results
does not have fixed sequence (i.e. is not logged dayly, weekly, monthly,
etc). However, I need to draw a monthly report on the results that have been
logged for the period. Using a vlookup function dont work for me, as I cannot
specify the actual dates for logging (because I dont always know), and draw
the results from that. I was playing around with storing the excel
spreadsheet as a DB, and creating a separate reporting spreadsheet. I then
use MS Query to draw the specific results for the perion, using a filter on
the date, to return only the data bor that period. However, if i want to
change the reporting period, I have to go back to the query everytime, and go
change the filtering criteria. Is there is way that I could specify the
filtering criteria within the reporting spreadsheet?


Regards

Lasca