Rotating Overtime Schedule HELP!

Hi, I am trying desperately to teach myself excel. My assignment is to create an excel spreadsheet that would list the employee's name in a the first column and then allow me to put the date in the adjacent column which would automatically move the person's name to the bottom of the list.

Employee name AB __ then when I enter the date they worked in the column it will move them to the bottom of the list. I hope that makes sense.

Any help can be appreciated.

Hi,

There are probably many ways of doing this. Which one you go for will very much depend on your specific project.

Are you looking for a Formula approach or a VBA approach?

Would the names go to the bottom of the list in the order you add the dates or the order of the dates themselves?
If the dates are added in chronological order then this wont be an issue as it will effectively be the same thing, but if you are likely to jump back and forward with dates when you enter them then it will make a difference to the approach taken.

BSB.

technically all I need it to do is to have a column of names on the left (actually sets of names) and the phone number next to it. The idea will be that once person a has taken an overtime, someone I enter something and it moves it to the bottom of the list. I found a youtube video for a baseball batting roster that would work but lord, I tried to do what he did and was so lost. I'm in over my head. I attached what I want it to look like. I think I'm just going to have to manually cut and paste each time :-( I really need to take a class on excel.

Have a look at the attached but Note you select the Employee # (cell D2) and the rest should auto rotate ... hopefully!!

MOVE ROWS.xlsx

Thank you so very much!

Thanks for your response.

Please make this as solved (above your first post top-right, Thread Tolls) and also please click on "Add Reputation" bottom left of this post (this helps me in the future when helping others).

All the best

how do you add names to the list

Hey Ursul,

I have the same issue that MBowers2 (I mean exactly the same) had and you help was awesome. Thank you.

What I would like to know is that, using your template: MOVE ROWS.xlsx,
instead of having to change the employee number manually, how can I create
a "next button" that will cycle to the next employee and then go back to the
top once it reaches the last name.

Thanks for any help you can provide.

did you get your rotating overtime list to work?

Originally Posted by ebsca475

did you get your rotating overtime list to work?

Sadly, no. Any advice?

Originally Posted by sawwas72

Sadly, no. Any advice?

Did you start your own thread as per the advice in post #9?

BSB

I'm new to this forum, but Ursul, your spreadsheet is awesome! I'm trying to read through the formula you input to create my own spreadsheet. We have different classes of employees that need to be put on their
rotation list. Can you help me out? I have about 4 classifications, with the following:

Class 1 - 2 positions
Class 2 - 2 positions
Class 3 - 3 positions
Class 4 - 6 positions

We don't have OT shifts. Can you help me? Did my explanation/question make sense?