+ Reply to Thread
Results 1 to 3 of 3

Reordering a list

  1. #1
    Registered User
    Join Date
    11-19-2009
    Location
    Fareham,England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Reordering a list

    Hi,

    I'm very new to doing anything overly complex in Excel.

    I've been trying for most of the night to do what is probably a fairly simple macro if you know what you are doing.
    Its a list used to decide who can have casual time off work.
    The idea being the person nearest the top of the list is given first choice at any time off, once they take the time off they move to the bottom of the list and everyone moves up a place.

    Basically its a list of names of staff at work, plus a few other cells with things like employee number etc.
    I was hoping to be able to do something to make it very simple to use.
    I have a column which I'd like to be able to put a value in, a simple 'x' for instance, really just a way of marking which people need to go to the bottom of the list.
    Then I'd like to run a macro which looks at column C and loops down the list moving anyone with an 'x' in thier column C at the bottom of the list.
    When the loop is finished, clearly the top of the list needs moving back to the top of the page.

    I've got as far as a loop which can figure out if it needs to do something for each row, but I'm having trouble getting it to select and paste the data needed.
    I understand the logic of how I want to make it work, just can't figure out the syntax to select a specific range with a variable in the row number and paste to a specific row.

    I have tried using offset to change cells but I think this is not a tidy way to do it (and could not make it work anyway)

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Reordering a list

    In a separate column, enter the date when they last chose a day off (or the date they chose).

    Then sort the two columns by date, descending.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    11-19-2009
    Location
    Fareham,England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Reordering a list

    While its not the way I was going, it does actually work as well, possibly even better.
    Thanks for looking at it with different eyes.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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