Here is what I am trying to do.
I have a simple sheet that has 6 columns and a growing number of rows. "A" is a date input by the user, the next 4 are random data and the last one, "E", is hour and Min (HH:MM), think total hours and min not time.
I would like to have a macro insert 2 rows when the date in column "A" changes to the next day. In the first row created I would like a total of column "E" and in column "D" I would like to have "Total".
My idea is if the user enters lots of data they can then trigger the macro and split the data by date and have a total of the time for that date. One other thing that I need to consider is if the user triggers the macro more than once (something that they will need to do) it doesn't add 2 additional rows and a second total.
I had some things working on different macros but not all and when I combined them things went real wrong. I guess I am saying I have no clue at this level, lol. :roll eyes:
Sorry I don't have any examples, I left everything at work.
Bookmarks