Macro to insert rows is not working accurately

**D794913** · 11-22-2016, 02:25 PM

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

**JOHN H. DAVIS** · 11-22-2016, 03:23 PM

Maybe:

Please Login or Register  to view this content.

**D794913** · 11-22-2016, 06:44 PM

John - Thank you for your quick response and hard work! I have spent at least 20 hours on the insert rows macro alone
so your help is greatly appreciated.

The sub-total and summing total is fantastic! Can you point me to where I can cut and paste this as a separate macro?
[/I]
For some reason it's not recognizing the cell value difference for the contract and customer columns (E&F). I can see that
you included both columns in your code - which makes sense. I didn't know how to do that but I understand the need.

I've attached the modified file with a tab sheet that ran your macro; I inserted brackets for an example of where
it's not catching the change of cell value. I included 'scratch' sheets for test use.

Assistance and thoughts are greatly appreciated.