+ Reply to Thread
Results 1 to 6 of 6

trying to insert a row and auto sum a column

  1. #1
    Registered User
    Join Date
    09-28-2009
    Location
    Alberta Canada
    MS-Off Ver
    Excel 2003
    Posts
    41

    trying to insert a row and auto sum a column

    Here is what I am trying to do.

    I have a simple sheet that has 6 columns and a growing number of rows. "A" is a date input by the user, the next 4 are random data and the last one, "E", is hour and Min (HH:MM), think total hours and min not time.

    I would like to have a macro insert 2 rows when the date in column "A" changes to the next day. In the first row created I would like a total of column "E" and in column "D" I would like to have "Total".

    My idea is if the user enters lots of data they can then trigger the macro and split the data by date and have a total of the time for that date. One other thing that I need to consider is if the user triggers the macro more than once (something that they will need to do) it doesn't add 2 additional rows and a second total.

    I had some things working on different macros but not all and when I combined them things went real wrong. I guess I am saying I have no clue at this level, lol. :roll eyes:

    Sorry I don't have any examples, I left everything at work.

  2. #2
    Forum Contributor
    Join Date
    03-21-2012
    Location
    Ho Chi Minh city
    MS-Off Ver
    Excel 2003
    Posts
    180

    Re: trying to insert a row and auto sum a column

    File????????????????????????????????????????????????

  3. #3
    Registered User
    Join Date
    09-28-2009
    Location
    Alberta Canada
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: trying to insert a row and auto sum a column

    Here is what I have. I formatted sheet 2 as I would like to see it work. The macro that works the closest it the ShowWeeks but there are problems with it, as you will see.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-28-2009
    Location
    Alberta Canada
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: trying to insert a row and auto sum a column

    Bump for solution.

  5. #5
    Registered User
    Join Date
    09-28-2009
    Location
    Alberta Canada
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: trying to insert a row and auto sum a column

    Here is the code I am using, I know it is a mess.

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    09-28-2009
    Location
    Alberta Canada
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: trying to insert a row and auto sum a column

    Bump one last time.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Complex VBA problem auto insert date and time, auto insert comment, etc.
    By rojashan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2013, 09:40 PM
  2. Auto insert in a column
    By Camarlengo in forum Excel General
    Replies: 2
    Last Post: 08-20-2011, 04:11 PM
  3. Auto insert value in a column
    By hunsnowboarder in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-02-2008, 06:22 AM
  4. auto insert column when sheet is opened
    By SMUGGLINGSTONES in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-11-2008, 02:21 PM
  5. Auto Insert Row When Column Amount Changes
    By Ronald \Tony\ Johnson in forum Excel General
    Replies: 2
    Last Post: 05-04-2005, 12:06 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