List data

[Guest]

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]

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

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

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

 

[Guest]

Thanks Debra, but I wanted to have this data on a seperate tab.
Can you take the data from one tab and have it filtered onto another?
I'd like to keep the original data in the original format.

 

[Debra Dalgleish]

In the 'FL0001 - Product List by Category' example, the data is filtered
to a different tab.
The 'FL0006 - Filter for Date Range' example shows you how to set up the
criteria for a date range.