charlie_580
Board Regular
- Joined
- Feb 3, 2007
- Messages
- 56
Hi
I have a sheet with numerous rows of data. Cell A is the start date, Cell B is the end date, Cell D is the total number of days in the period and Cell E is the number of hours.
What I would like to do, is use a macro to split the rows into 5 and 7 month periods. April to August and September to March. So I want to insert 2 blank rows between the end of March and start of April, and insert 2 rows between the end of August and start of September. These dates can fall within any year, but will always be in oldest to newest order.
Once the blank rows are inserted, I then need to total the number of days in Column D and the number of Hours in Column E. There could be blank cells in these columns as well as text, both of which can be ignored.
I have included a screenshot test sheet showing how the finished sheet will look to hopefully help explain what the finished sheet will look like.
Thanks
I have a sheet with numerous rows of data. Cell A is the start date, Cell B is the end date, Cell D is the total number of days in the period and Cell E is the number of hours.
What I would like to do, is use a macro to split the rows into 5 and 7 month periods. April to August and September to March. So I want to insert 2 blank rows between the end of March and start of April, and insert 2 rows between the end of August and start of September. These dates can fall within any year, but will always be in oldest to newest order.
Once the blank rows are inserted, I then need to total the number of days in Column D and the number of Hours in Column E. There could be blank cells in these columns as well as text, both of which can be ignored.
I have included a screenshot test sheet showing how the finished sheet will look to hopefully help explain what the finished sheet will look like.
Thanks