Sorting Cells Across Worksheets

D

dbg

Hi Every Body, I am trying to do a spreadsheet for my church and
appreciate any help. i have attached the spreadsheet!


When I add a first or last name to the first sheet it appears on th
following two sheets (using a formula (=T(Names!A2)).

When I sort the first sheet by first or last names, the name columns o
sheets two and three sort also, which is good.

But, the other columns on sheets two and three don't sort with th
names. I need all the columns in a row to move together when a sort i
done on first or last name on the first page.

All the info in columns C through M for a person (row) needs to mov
with the person (row) when all the records are sorted by name on th
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 workshee
one.

I really appreciate any help

Thanx

Attachment filename: sg database.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56568
 
D

Dave Peterson

See one response at your first post.

dbg < said:
Hi Every Body, I am trying to do a spreadsheet for my church and I
appreciate any help. i have attached the spreadsheet!

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.

I really appreciate any help

Thanxs

Attachment filename: sg database.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=565687
Click to expand...
 
Top