Running Clock/Automatically Filter Merged Cell Rows

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

Originally Posted by Leith Ross

Hello hwtcrl,

What UserForm are you referring to? The workbook has no VBA macros.

Leith,

I have attached a simple version of my project that hopefully will answer your question and if you need more detail I will provide anything you need.

I do not have the ability to upload my actual project, so this is the best I can do for now.

Cheers!

Book1.xlsm

Bump