Hi
only a general idea:
have a look at VLOOKUP (http://www.contextures.com/xlFunctions02.html)
Also you may consider using a pivot table. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Al" schrieb im Newsbeitrag
...
in tab A I have my Raw data. One of the columns is of names. what I
want to
do is in Tab B, where I have my analysis and my names already listed,
and I
want to copy the data from tab A to Tab B based on that name value.
I think
it is a lookup function but I am not sure. Any help is of course
appreciated.