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

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

Try using VLOOKUP - what you want to enter is =VLOOKUP(Cell Reference, Table
Array, Column Ref #, FALSE). enter this in each cell you want data
retrievedto - for example on the worksheet your assembling the data on, go to
column B Cell 1 and enter the reference as A1, this will look for the name in
A1 when you enter it. Now for the table array, go to the sheet where all the
tech's information is listed, & drag and select that whole array that you
want to pull data from (all columns and rows). now enter the number
representing the column you want to pull data from Date=2, Address=3, and
finally enter "FALSE" which will return only an exact match of the name.

What you are telling excel to do is go to another worksheet, look up this
name in column A on that sheet, and return the value in column B beside that
name back to this cell. Enter that formula in each cell (date, address, id#,
etc.) changing the column reference number accordingly.

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