Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

excel query

  • 07-08-2005 10:05pm
    #1
    micks
    Registered Users, Registered Users 2 Posts: 840 ✭✭✭


    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


Comments

  • #2
    Kinetic^
    Closed Accounts Posts: 13,249 ✭✭✭✭Kinetic^


    micks wrote:
    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

    If you highlight all the rows that have info on them with mouse,the are will go blue. then tab across to the top of the column that you want to sort and then sort it. this should work,if not come back to me.


  • #3
    micks
    Registered Users, Registered Users 2 Posts: 840 ✭✭✭micks


    cheers for reply
    i cant get that to work
    but dont quite understand it - i am not doing the "sort " in the sheet where the details are kept i do it in the History sheet

    basically the details worksheet has 2 rows whose contents are controlled by =INDEX('History records'!$C:$C,) matching cells from another sheet
    and then 3 rows (phone ,email,address) that i have typed in to correspond with the name
    when i sort the first sheet ,the names on the history sheet change as they are controlled by formula
    but the other details stay in the cells where they are typed

    cheers


Advertisement