+ Reply to Thread
Results 1 to 11 of 11

Checkbox dont follow with the A-Z sorting

  1. #1
    Registered User
    Join Date
    11-05-2019
    Location
    DK
    MS-Off Ver
    2013
    Posts
    6

    Question Checkbox dont follow with the A-Z sorting

    (im pretty new to excel, and i use excel 2013)

    im trying to create a list where i can check off when a task is completet.
    I have added a sorting menu, but when i click it to sort A-Z the check boxes dont follow their rows. It more looks like they jump randomly

    I have looked all over the web, and i havent found a solution.
    I have attached images of what i experience + the excel doc

    Can someone help me please

    1.JPG
    2.JPG
    Attached Files Attached Files
    Last edited by blomselomse; 11-05-2019 at 08:13 AM.

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2013
    Posts
    3,479

    Re: Checkbox dont follow with the A-Z sorting

    Hi there,

    When you perform the Sort operation, have you included Column J (the hidden column) in the range of cells to be sorted? The cells in Column J are linked to the CheckBoxes in Column B.


    Hope this helps - please let me know how you get on.

    Regards,

    Greg M

  3. #3
    Registered User
    Join Date
    11-05-2019
    Location
    DK
    MS-Off Ver
    2013
    Posts
    6

    Re: Checkbox dont follow with the A-Z sorting

    Hi Greg,

    thank you for your reply.
    the J column should be included. When i press Advances filter the list range is "$A$64:$J$110" wich i assume includes J?
    (its my first excel doc, so i might be doing something wrong that should be obvious)

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2013
    Posts
    3,479

    Re: Checkbox dont follow with the A-Z sorting

    Hi again,

    Thanks for your feedback.

    Your first post mentions "Sort A-Z" but your second post mentions "Advanced Filter". There's a significant difference between a Sort operation and a Filter operation.

    Do you want to sort the two blocks of data so that (e.g.) all of the "Done" items appear at the bottom of each block?

    Regards,

    Greg M

  5. #5
    Registered User
    Join Date
    11-05-2019
    Location
    DK
    MS-Off Ver
    2013
    Posts
    6

    Re: Checkbox dont follow with the A-Z sorting

    arh, ok.

    The idea is that i would like to be able to check off items in the To Do box so the row turns green, and then be able to sort the tasks after
    "Hvornår/ Område = When/ Subject"
    and by "Ansvarlig = Responsible"

    So that during the period im running the project i can see who needs to finish their task, and when everything in regards of the tradeshow booth is in order, and so on.

    This is a template document i want to use for all the event projects i run.

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    8,937

    Re: Checkbox dont follow with the A-Z sorting

    The problem is that the Linked cell does not change when the data is sorted.
    Select all the checkboxes & change the Property to "Dont move or size with the cells"

  7. #7
    Registered User
    Join Date
    11-05-2019
    Location
    DK
    MS-Off Ver
    2013
    Posts
    6

    Re: Checkbox dont follow with the A-Z sorting

    Thanks Fluff, its working great now much appreaciated to both of you, thank you for helping me

    Attachment 648274

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    8,937

    Re: Checkbox dont follow with the A-Z sorting

    You're welcome & thanks for the feedback

  9. #9
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2013
    Posts
    3,479

    Re: Checkbox dont follow with the A-Z sorting

    Hi again,

    Ok, to sort the first block of your data you should do the following:

    Select rows 3:20

    Click on Data >> Sort on the Ribbon

    Tick the "My data has headers" CheckBox on the "Sort" DialogBox

    Select "Hvornar/ Omrade" from the "Sort by" dropdown list

    Click on "Add Level"

    Select "Hvad" from the "Then by" dropdown list

    Click on "OK"


    Hope this helps - please let me know how you get on.

    Regards,

    Greg M

  10. #10
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2013
    Posts
    3,479

    Re: Checkbox dont follow with the A-Z sorting

    Nice one Fluff - well spotted!"

    Regards,

    Greg M

  11. #11
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    8,937

    Re: Checkbox dont follow with the A-Z sorting

    Thanks for that

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Syntax for sorting text as numbers - Dates do not follow if crossing a month
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-06-2018, 11:59 AM
  2. EXCEL COMPARING with EACH OTHER IN SAME RANGE
    By mistrymah in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-15-2014, 04:42 AM
  3. Excel Checkbox Sorting Help Required
    By richardv24 in forum Excel General
    Replies: 0
    Last Post: 05-22-2013, 04:08 PM
  4. Valdiation to follow cell after sorting.
    By Gonzo714 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-26-2012, 12:13 AM
  5. Excel 2007 : Sorting my Estimate Log for follow-up
    By ttjacwr in forum Excel General
    Replies: 4
    Last Post: 12-21-2011, 08:40 AM
  6. Replies: 1
    Last Post: 12-14-2009, 05:20 PM
  7. colors of bar charted data don't follow data after sorting
    By Frankgjr in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-17-2006, 08:40 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1