oksox
06-14-2017, 01:56 PM
Hi,
I'm working on a small code to copy data from one worksheet and past in a report on the other. I'm really close to finishing up, but my limited understanding of VBA has me scratching my head. Hoping someone out there wouldn't mind to help me out.
I've attached a spreadsheet for you to view and code. It is copying correctly based on the criteria, and pasting in the blue highlights. But what I need to do now is have it insert a new row on the yellow hightlighted row for, and then paste on that new row. This will keep 2 rows between the data and the subtotal.
Any help would be greatly appreciated.
I'm working on a small code to copy data from one worksheet and past in a report on the other. I'm really close to finishing up, but my limited understanding of VBA has me scratching my head. Hoping someone out there wouldn't mind to help me out.
I've attached a spreadsheet for you to view and code. It is copying correctly based on the criteria, and pasting in the blue highlights. But what I need to do now is have it insert a new row on the yellow hightlighted row for, and then paste on that new row. This will keep 2 rows between the data and the subtotal.
Any help would be greatly appreciated.