My Question is how do I create a worksheet that contains only rows that
contain a certain name on a different worksheet.
I have an exported list of data that contains information for different
users. Would like a formula that will return the row only if it contains the
name desired.

once I figure out a way to creat that list I also want to take out any rows
that show a certain date. I'll attempt to make an exsample below, but the
real data will of course be much larger:

A B C D

Jim 03/26/07 Apples $200
Jim 03/27/07 Apples $200
Jane 03/25/07 Apples $200
Jim 03/23/07 Apples $200
Jim 03/25/07 Apples $200
Jane 03/23/07 Apples $200

Requesting to show only rows that show "Jim" + " before 03/26/07"

Result:

Jim 03/23/07 Apples $200
Jim 03/25/07 Apples $200


Thanks in advance. If you require further explaination please just ask. I
will attempt to be more descriptive.