I want to move the top row down to the bottom of the sheet once the current date has passed. I think VBA code would work best, but am new to using VBA. I am attaching a mini sheet. I see code in previous posts for moving a row to a new sheet or to delete the row once it is moved. I need the row to remain intact. Any assistance would be appreciated.
| DWU-KERNEL ACTIVITIES.xlsx | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | DWU Baseball | ||||||||
| 2 | Date | Time | Opponent | Producer | Camera Person | Announcer | |||
| 3 | 3/2/2025 | 12:00 PM | Northern State | Caleb | Zach | Caleb | |||
| 4 | 3:00 PM | Northern State | Caleb | Zach | Caleb | ||||
| 5 | |||||||||
| 6 | 3/18/2025 | 3:00 PM | Dakota State | ||||||
| 7 | |||||||||
| 8 | 3/21/2025 | 12:00 PM | Hastings | Dane | |||||
| 9 | 2:30 PM | Hastings | Dane | ||||||
| 10 | |||||||||
| 11 | 3/25/2025 | TBA | Valley City State | ||||||
| 12 | |||||||||
| 13 | 3/29/2025 | 1:00 PM | Doane | ||||||
| 14 | 3:30 PM | Doane | |||||||
| 15 | |||||||||
| 16 | 4/5/2025 | 1:00 PM | Mount Marty | ||||||
| 17 | 3:00 PM | Mount Marty | |||||||
| 18 | |||||||||
| 19 | 4/6/2025 | 1:00 PM | Mount Marty | Zach | |||||
| 20 | 3:00 PM | Mount Marty | Zach | ||||||
| 21 | |||||||||
| 22 | 4/12/2025 | TBA | Northwestern | ||||||
| 23 | TBA | Northwestern | |||||||
| 24 | |||||||||
| 25 | 4/13/2025 | 1:00 PM | Morningside | ||||||
| 26 | 3:30 PM | Morningside | |||||||
| 27 | |||||||||
| 28 | 4/19/2025 | TBA | Briar Cliff | ||||||
| 29 | TBA | Briar Cliff | |||||||
| 30 | |||||||||
| 31 | |||||||||
| 32 | |||||||||
Sheet2 | |||||||||
