Hello!
I am looking for a way or VBA code(Unsure of what would work better) that would automatically sort the data coming into a table by current date to oldest date. Below is how i have my table set up, so ideally the table would automatically sort by column B once the data is inputted
Column a b c
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Any suggestions greatly appreciated
thanks!
I am looking for a way or VBA code(Unsure of what would work better) that would automatically sort the data coming into a table by current date to oldest date. Below is how i have my table set up, so ideally the table would automatically sort by column B once the data is inputted
Column a b c
Unit Type | Move In Date | Rent Amount |
3x3sw-d | 06/26/2016 | 3,010.00 |
2x2sw-bu | 09/01/2015 | 2,345.00 |
2x2sw-f | 10/30/2016 | 2,660.00 |
2x2sw-g | 06/05/2014 | 2,470.00 |
2x2sw-c | 06/01/2012 | 2,325.00 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Any suggestions greatly appreciated
thanks!