Return ALL results and ONLY those result that match a field

[emryjy]

Hello. I have a field that the user can select an option (1,2, or 3) for the following table.

2 11/28/2012 80000
2 2/10/2013 100000
2 5/11/2011 90000
3 10/21/1995 10000
3 2/17/1996 20000
3 3/3/2008 120000
1 8/27/2011 30000
1 11/9/2013 60000
1 10/28/2014 60000
1 2/13/2011 40000
2 4/8/2007 20000
2 7/8/2006 50000
2 7/29/2009 50000
2 1/13/2011 20000

When the user selects one of the numbers, the excel will show all the results from 1, and all the results from 2, etc.

So if the user selects 2: it should return only the following:

11/28/2012 80000
2/10/2013 100000
5/11/2011 90000
4/8/2007 20000
7/8/2006 50000
7/29/2009 50000
1/13/2011 20000

I know I can do it with pivottables, but want to have it in sheet thanks.

[Kyle123]

How about an autofilter?

[emryjy]

The user selection field (criteria) is on one sheet and the data table is on another. I need it to return only the results back to the first sheet where the user is selecting 1,2,3...

Thanks!

[Kyle123]

Then you'll need to post your workbook, since you'll need code. I'd always recommend keeping things simple though so I'd still recommend an autofilter