lookup and paste row into separate sheet

[lmc]

This is probably basic stuff, but just cant get my head round it.

I have been give a workbook containing several worksheets which ar
effectively minutes of a meeting about individual students.

Column headings and data are:

(Tutor Group) (name) (comment) (date fo
review)
7Y Lisa good behaviour
29/03/04

I want to be able to lookup from the Name column on all the sheets, an
extract the rows to a separate sheet that correspond to the name I hav
looked up.

I have tried h-lookup, but there seems to be a problem referencin
several sheets, and also to get the whole row copied into the new shee
is proving a problem. I have no idea how to go about it. Any ideas?

I had thought of creating a database, but as the person who types th
minutes actually does it in the meeting, its obviously easier for he
to use an excel spreadsheet in the above format.

What I basically want to be able to do is create a separate repor
based on the name - with all information in the row that relates to th
name.

Any help would be gratefully received

 

[JMay]

Use at the menu, Data, Filter, Auto-Filter
Filter on Name,
then Highlight Header and current rows (by selecting the header rows) copy
and Paste to New worksheet.
Go to: http://www.contextures.com/excelfiles.html#Filter
and
Under Filters, look for:
Create New Sheets from Filtered List
too cool.....
HTH

 

[lmc]

Thats great thanks, but I wanted to try avoiding going through the
sheets individually myself. I want to find a way that excel can lookup
a name in all the columns in all the sheets in the workbook, and then
bring back copies of the rows to a new sheet?