I would like an Excel 2007/2010 Macro to sort spreadsheets like attached “Time-Unsorted” to “Time-Sorted”. In short this involves the following steps:
Sort by date; oldest to newest
Group all dates together and add row beneath each group
Add all Hours from one group together and place total in new row as indicated
Change color of total hours, for each group, to red
This should be a macro that can be loaded and used in any MS Excel 2007 or 2010 workbook.
Thank you.