You could do this with programming and an Advanced Filter. There's an
example he

http://www.contextures.com/excelfiles.html

Under Filters, look for 'FL0006 - Filter for Date Range'
or 'FL0001 - Product List by Category'

Brian wrote:
I have a tab on a spreadsheet that contains various rows of data. (ie dates,
interest rates, principal)
On a seperate tab, I'd like to create a list of this data that meets
specific criteria.
For example, I'd like this seperate tab to automatically update with a
listing of the info from the first tab when I plug in specific date.
Is there any way to pull data from one tab to another without duplicating
the info? I've considered using VLOOKUP, but that will only give me the
first set of data that meets the requirement....how can I get the next row of
data to populate?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html