Closed Thread
Results 1 to 2 of 2

Macro to insert rows is not working accurately

  1. #1
    Registered User
    Join Date
    03-24-2013
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2013
    Posts
    11

    Macro to insert rows is not working accurately

    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
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,916

    Re: Macro to insert rows is not working accurately

    Please do not duplicate threads. If you want it in a different forum feel free to ask a moderator for help.

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 9
    Last Post: 02-09-2016, 11:42 AM
  2. Replies: 2
    Last Post: 04-19-2015, 01:36 PM
  3. [SOLVED] Insert Row Macro not working all of a sudden...
    By rjw524 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-01-2015, 12:33 AM
  4. Replies: 8
    Last Post: 08-16-2014, 01:27 PM
  5. Working Macro Code to insert random value. Only C48 needs to go to G15 etc.
    By Phixtit in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2009, 06:56 PM
  6. [SOLVED] Insert Row macro not working
    By Acct Supr - DCTC in forum Excel General
    Replies: 3
    Last Post: 10-06-2005, 09:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1