Move Row to Bottom based on Cell Value

[CRTuser]

Hi!

New here and trying to learn some more complicated Excel tools. I have a spreadsheet where I want entire rows to drop down to the bottom when the value of a cell is greater than todays date. The cells of interest would be starting at G17 on. Any help would be amazing!

 

[Joe4]

Welcome to the Board!

That is certainly do-able, but will require VBA and we probably need a bit more information, such as:

What is the structure of your data?
What rows/columns are populated?
What you required columns (i.e. for every row of data, what columns MUST be populated with a value)?

When do you want this VBA to be run?
Manually, on command? If so, should it run against all the data on the sheet?
Or, should it run automatically as data is being entered into column G? If so, how exactly is column G being populated (manually, by formula, import, copy/paste, etc)?