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