Hi,

Advanced Filtering should get the results you are looking for.

John

"Gringarlow" wrote:

Is there a way to retrieve all of the rows of data associated with one key
cell. I have a table of data with several Tech Names in it, each Tech could
have several rows of data, all the columns have the same format.
ex:
Col a - Tech Name
Col b - Date
Col c - address
etc....
What I want to do, if possible, is select a tech's name from a seperate
sheet in the workbook and have all of that techs rows of data appear. Similar
to clicking on a cell in a pivot table and getting a new sheet of data. A
pivot table won't create what I need from the data.
Thanks