Command Button "add and next"

[dcaba79]

Great info on this site but I've tried search to find info on my current worksheet. I have a work sheet where i track people standing on line. I would like 2 command buttons one stating add and one stating next.

The add button i would like it to get the information from worksheet "Line" cell "b8" and write it to worksheet "data" column "b" but i would like to keep the info on a loop between "b2:b35" . I also created a code where it writes the time next to the info once its inputed so on a1 i have the time automatically inputed ..

on worksheet "line" i need the next 3 people on line so it will be shown on "b2 - 1st" "b3-2nd" "b4-3rd"

the next button just clears the first person from worksheet"data" and moves up the list or reads the next person on line. I've attached the worksheet as a sample there is 6 physical lines in total..

in the add box cell "b8" i would like when you press the enter key the data is automatically added and i dont have to use the mouse.