Is it possible to move entire rows (A:I at least) up or down based on either date cell or a status cell (If Statement).
I don't know if I explained that very well.
I have a Toggle Button that Toggles between Edit state and Operational State.
Edit state: I edit everything not worrying about sorting the dates Sequentially.
Operational State triggers the Macro that sorts the Rows based on the Date nearest date being Row1, then Row2 Etc Etc. Leapfrog? ;-) Man it's Hard Work being Lazy..