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 fill
names and roles etc in sheets and only change the original "history
records" sheet
all is fine except for the detail sheet where i have added phone
numbers,address etc to rows which have been filled by =INDEX('History
records'!$C:$C,) and when i sort by my new active/inactive column the
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
micks


--
micks
------------------------------------------------------------------------
micks's Profile: http://www.excelforum.com/member.php...o&userid=26021
View this thread: http://www.excelforum.com/showthread...hreadid=393747

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"micks" wrote in message
all is fine except for the detail sheet where i have added phone
numbers,address etc to rows which have been filled by =INDEX('History
records'!$C:$C,) and when i sort by my new active/inactive column the
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
micks


--
micks
------------------------------------------------------------------------
micks's Profile: http://www.excelforum.com/member.php...o&userid=26021
View this thread: http://www.excelforum.com/showthread...hreadid=393747

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 names
"copied " from sheet i sort, using a formula
but the other columns that containing phone no's etc dont match the
names as the names move with the sort

i'm confusing myself at this stage
cheers



--
micks
------------------------------------------------------------------------
micks's Profile: http://www.excelforum.com/member.php...o&userid=26021
View this thread: http://www.excelforum.com/showthread...hreadid=393747

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"micks" wrote in message
...

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 names
"copied " from sheet i sort, using a formula
but the other columns that containing phone no's etc dont match the
names as the names move with the sort

i'm confusing myself at this stage
cheers



--
micks
------------------------------------------------------------------------
micks's Profile: http://www.excelforum.com/member.php...o&userid=26021
View this thread: http://www.excelforum.com/showthread...hreadid=393747

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


--
micks
------------------------------------------------------------------------
micks's Profile: http://www.excelforum.com/member.php...o&userid=26021
View this thread: http://www.excelforum.com/showthread...hreadid=393747

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

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"micks" wrote in message
...

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


--
micks
------------------------------------------------------------------------
micks's Profile: http://www.excelforum.com/member.php...o&userid=26021
View this thread: http://www.excelforum.com/showthread...hreadid=393747