sort problem with worksheets

M

micks

I have a spreadsheet for membership to a club
first sheet is a history with roles,etc for each year
then i have a sheet for each year
and finally a member details sheet
i have added a "active/inactive member" column to sort the members by
but my problem is

i use =INDEX('History records'!$C:$C,) and similar formula to fil
names and roles etc in sheets and only change the original "histor
records" sheet
all is fine except for the detail sheet where i have added phon
numbers,address etc to rows which have been filled by =INDEX('Histor
records'!$C:$C,) and when i sort by my new active/inactive column th
names etc change but the details stay where i have entered them
is there any way to keep the rows together in the detail sheet

hope this is clear
any help appreciated

cheers
mick
 
D

David McRitchie

Hi Micks,
When you sort by columns you must select the columns that are to stay
together, this usually means that you would select all cells on the workbook
using Ctrl+A (except in Excel 2003).

More information on sorting on my page
http://www.mvps.org/dmcritchie/excel/sorting.htm

You probably have a single cell selection to start with so Excel expands
that to the current region (Ctrl+Shift+*) which stops where you have
an empty column or an empty row.

BTW, you probably added the phone number at the end after an empty column.
I find for a name and address list it is easiest to read if you put the phone number
immediately the left of the name, and the address to the right of the name then
they are both close to the name.

Note: To ensure that you select all cells In Excel 2003 you must use Ctrl+Shift+SpaceBar
 
M

micks

cheers for the reply
i'd already tried this
but it doesnt sort my problem
i prob cant do what i want to do
the sheet i do the sorting on is ok but the "details" one has the name
"copied " from sheet i sort, using a formula
but the other columns that containing phone no's etc dont match th
names as the names move with the sort

i'm confusing myself at this stage
cheers
:rolleyes
 
D

David McRitchie

Hi Micks,
Not much to go on. If your detail sheet already has names that
don't match the addresses on the same row then they aren't going
to get better.

Some things to think about.
VLOOKUP Worksheet Function if you have good detail data somewhere
that you can match up from your sheets.

Restore from a Backup if you have one of those hanging around.

Filter, may allow use of a master sheet to be used to filter on some element
need to distinguish a customized listing.
 
M

micks

sorry its hard to explain what i am at
i have the correct data ie names matching addresses etc
but my main sheet is all over the and i wanted to have active members
at the top
i added an active/inactive column and sorted using this new column
but then the details/addreses etc got mixed up

this vlookup might be the way

i can do changes manually to sort it out but i'd rather leave it in the
present format if possible

thanks for your time
 
D

David McRitchie

Good that you have not lost your data, it sure sounded different
before.

With filtering you can look at all of the data, active only, inactive only
from any of those you can print or even copy and paste or use
Mail Merge to print labels all without really touching your data.
http://www.contextures.com/tiptech.html read about filtering
 
Top