Assistance please- Every week and at the end of each month, for project costing/ customer invoicing, I download time entries. The download includes quite a bit of data that I decipher/organize via macros. While all self-taught, I am running into difficulty with inserting 2 empty rows accurately once cell values have changed.
Attached is a file that includes what the data looks like after my first macro. The data is sorted by Author, Contract, and Customer. The need is to insert 2 rows when the contract and customer change. When I run my insert 2 rows macro, it is not inserting the rows where it should.
Once the data is sorted and the 2 rows are inserted, I subtotal each set and a total at the end.
Would someone be able to help me on 2 issues: first, correct my macro so that the 2 rows are inserted accurately; is it possible to create a macro that will sub-total and also total all of the sums?
Many thanks for assistance
Bookmarks