Sorting Cells Across Worksheets

  • Thread starter Thread starter dbg
  • Start date Start date
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked cells between worksheets and sorting 2
Auto sort when worksheet/book opened 4
Help to create a macro 2
Excel changes formula after data sort/filter, please help. 1
Excel Is this possible?? 3
Sort Contiguous Columns - Danger 3
Remove date format? 3
How to filter rows data based on background color of individual cells 1

Back
Top