Hello,
I've been experimenting with Macro's and VB for a little time and created some easy functions and modification, but this is just way beyond my reach and hoped maybe someone could help me out. I attached the Excel sheet to further clarify my case.
I'm trying to insert a yellow row when the day changes, as you see in this Excel sheet, a yellow row is inserted every time the day changes in the E-column, i.e. from 15th of December to 16th of December, from 16th to 17th, from 17th to 18th, etc.
Also, this yellow row should contain a SUM function in the F column, that counts the hours from the first row till the row before the inserted yellow row, and another SUM function in the N-column that subtracts this 'SUM of the column F', with the 'SUM of the N-column' that counts the hours from the first row till the row before the yellow. The second yellow row does the SUM functions between the first yellow row and the second yellow row, etc.
Basically, all the rows - except for the yellow ones - are being generated automatically, and instead of adding the yellow rows manually, I'd like to automate it with a Macro. Sheet 1 is what the result should be, and Sheet 2 is the standard layout.
Any help would be greatly appreciated!
Bookmarks