Sorting Across Worksheets

[Randall Senn]

If the data on the 2nd worksheet is a subset of the data
on the first, you might be able to use the vlookup
function against the names on the 2nd worksheet, bringing
in data from the 1st worksheet.

-----Original Message-----
Hi Every Body, I am trying to do a spreadsheet for my

church and I appreciate any help.

When I add a first or last name to the first sheet it

appears on the following two sheets (using a formula (=T
(Names!A2)).

When I sort the first sheet by first or last names, the

name columns on sheets two and three sort also, which is
good.

But, the other columns on sheets two and three don't

sort with the names. I need all the columns in a row to
move together when a sort is done on first or last name
on the first page.

All the info in columns C through M for a person (row)

needs to move with the person (row) when all the records
are sorted by name on the first sheet. Is this possible?

I have a Workbook with 3 sheets

1) Names 2) Keywords 3) Worship

Cell "A + B" = First and Last name on all Work Sheets

Cell "C" on thru ? = needs to move with the

modifications on worksheet one.

 

[Guest]

only the first and last name are subsets on all pages...

vlookup (scratching head)?