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?