date range lookup
I have a time tracking workbook that looks like this:
Work Order Time IN Time OUT
1234 2/13/2007 15:11 2/13/2007 16:28
1234 2/13/2007 16:55 2/13/2007 17:30
5678 2/14/2007 7:47 2/14/2007 12:00
5678 2/14/2007 12:30 2/14/2007 14:23
I want to enter a beginning and ending date into my destination workbook,
then have it search the data in the time tracking workbook and return me a
list of work orders within that time range.
Any suggestions on where is the best place to start?
Even a brief outline of the logic that would need to be applied would be
helpful at this point.
|