I have attached an example workbook for reference.

I have a running clock in a merged cell like the example workbook.

1) Is it possible to compare the time in row 1 with the current time and if the current time is greater then a userform will show?

2) If that current time is greater than row 1's time the userform has a button to clear cells that contain the "A/B/C/D/Time" <----I have this figured out

3) Once the first row has cleared move the rest of the rows "up" and the process starts over again

4) If row 4 gets new data entered into it via a userform I have already working, upon clicking the button that puts user data into row 4, rows 1-4 automatically sort based on the time column (if row 4's time was 10:00 it would get moved to the top of the list to be checked against the running clock)

5) I'm sorry this is such a complex question I'm sure the code is going to be outrageous, if anyone has the time to waste on this I'd really appreciate it!

Book1.xlsm