Sorting Across Worksheets

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

You need to highlight all the cells you want to sort, not
just the one column, then they'll stay together.

-----Original Message-----
Hi Every Body, I am trying to do a spreadsheet for my
Click to expand...
church and I appreciate any help.
When I add a first or last name to the first sheet it
Click to expand...
appears on the following two sheets (using a formula (=T
(Names!A2)).
When I sort the first sheet by first or last names, the
Click to expand...
name columns on sheets two and three sort also, which is
good.
But, the other columns on sheets two and three don't
Click to expand...
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)
Click to expand...
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
Click to expand...
modifications on worksheet one.
 
Don I thank you for your response
but i am not actively sorting any sheet other than the first one - the subsequent sheets that have first and last name info reflect the changes because of the formula... but i need to add additional information to the rows on subsequent pages that i need to move with thier associated first and last name..

any ideas?
 
AH....I thought all your data was on one sheet, then
called up to other sheets through formulas. I've got a
Workbook set up this way. All my data entry is on one
sheet, through formulas I call data to additional
sheets. When a sort is done on the data entry sheet, all
the sheets are sorted along with all the pertinent data.
But all data is entered on the Data Entry Sheet.

Don

-----Original Message-----
Don I thank you for your response -
but i am not actively sorting any sheet other than the
Click to expand...
first one - the subsequent sheets that have first and
last name info reflect the changes because of the
formula... but i need to add additional information to
the rows on subsequent pages that i need to move with
thier associated first and last name...
 
Wanted to add, you might want to use a macro to do your
sorts for you........makes life a lot easier....:)

Don
 
Sorry if i didnt explain my self properl

Worksheet one
first, last, telephone, address, etc, ect

worksheet tw
first, last (replicated from first page), misc info, misc info, misc info, misc info, misc info,

worksheet thre
first, last (replicated from first page), other misc info, other misc info, other misc info, other misc info, other misc info

its the "misc info" that i need to "move" with the first and last when i sort that first pag
same thin
its the "other misc info" that i need to "move" with the first and last when i sort that first pag

dows this make sense?
 
Yeah thats what i have been thinking --- BU

i will be sharing this workbook with some of my group and I would expect that a lot of people have

macro protection enabled by default (norton etc

and then it gets sticky ya know
 
As I said above, only way I know is to get all your input
data on one sheet. If you need "Names" as a separate
sheet, generate it with formulas from the "Data Entry"
sheet. Then sort the Data Sheet. You could add a macro
to do this and if macro's were disabled, they'd have to
sort manually.

There might be another answer for you out there.....will
be watching to see who jumps in here...

Don

-----Original Message-----
Yeah thats what i have been thinking --- BUT

i will be sharing this workbook with some of my group
Click to expand...
and I would expect that a lot of people have
 
Back
Top