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)
Bookmarks