Sorting a Table

[derbycityroller]

I have a table with at least 8 columns and infinite rows, as exampled below. I would like to be able to, on another sheet, sort through this data a little more efficiently without using a pivot table if possible. I would like to, from a drop down box, be able to select the Employee name and it find all record of that employee in the table and put it into another table on the seperate sheet. So for example On Sheet Two I have a drop down box selecting Joe. I would then like all Rows containing Joe's name, to populate into a new table on Sheet 2. Is this possible? Would a Pivot table be more effective? Thanks


[TABLE="width: 500"]
<TBODY>[TR]
[TD]Week[/TD]
[TD]Name[/TD]
[TD]Client[/TD]
[TD]Hours[/TD]
[TD]Units[/TD]
[TD]Goal Units per Hour[/TD]
[TD]% Effective[/TD]
[TD]Supervisor[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Joe[/TD]
[TD]A[/TD]
[TD]5[/TD]
[TD]100[/TD]
[TD]15[/TD]
[TD]133.33%[/TD]
[TD]Jim[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Joe[/TD]
[TD]B[/TD]
[TD]7[/TD]
[TD]205[/TD]
[TD]20[/TD]
[TD]146.43%[/TD]
[TD]Jim[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Sally[/TD]
[TD]C[/TD]
[TD]etc[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Sally[/TD]
[TD]A[/TD]
[TD]etc[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

 

[snb_]

Ribbon / insert / table is what you need.
Check it out.

 

[derbycityroller]

Let me clarify/elaborate. I want to be able to, on Sheet 2 of my workbook, use a drop down box to select a name of an employee (Joe) and have all rows with Joe's data, displayed. But Joe's data has numerous rows and is not sorted by name, its sorted by Date so its not in consecutive order.... Does that make sense? I cant figure out how to do it....

Thanks