+ Reply to Thread
Page 1 of 10 1 2 3 ... LastLast
Results 1 to 15 of 137

Adding columns to a macro

  1. #1
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Adding columns to a macro

    Hi

    Can someone help modify the macro so that in column G instead of the total per driver we have the equation =D26/F26.

    I will need this to happen on each drivers total line in column G

    Thanks

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by TERRI LEE; 09-19-2012 at 05:55 AM.

  2. #2
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Adding columns to macro

    Hi

    I have attached a copy of the new columns I need.

    Add in columns H - S as per schedule. These formulas only need to be on the total lines per driver.It must automatically work with its formulas.

    In column S - I need a formula for the calculation please.

    Then over all I would like the document to have the total lines in Bold Red as I have done here manually. I would like the font to all be sized to "8" as well as the borders done as I have here.

    Once all this is done is it possible to copy only the 'totals per driver' rows into a new sheet?

    I hope this can be achieved.

    Thanks
    Terri
    Attached Files Attached Files
    Last edited by TERRI LEE; 09-20-2012 at 03:41 AM.

  3. #3
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: Adding columns to a macro

    Add in columns H - S as per schedule. These formulas only need to be on the total lines per driver.It must automatically work with its formulas.
    What do you mean by add in columns H - S? The columns already exist. Are they missing from the original data?

    Then over all I would like the document to have the total lines in Bold Red as I have done here manually. I would like the font to all be sized to "8" as well as the borders done as I have here.
    Did you mean Blue and not Red? The file shows blue.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Re: Adding columns to a macro

    Yes they are. They are new columns that I added so that you can see what I want.

    As long as the colour is different to all the info inbetween.
    Last edited by Cutter; 09-19-2012 at 04:40 PM. Reason: Removed whole post quote

  5. #5
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: Adding columns to a macro

    What do you mean by add in columns H - S? The columns already exist. Are they missing from the original data?

  6. #6
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Re: Adding columns to a macro

    Yes they are. They are new columns that I added so that you can see what I want.

  7. #7
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: Adding columns to a macro

    It will be good if you upload the "before" data o we get a picture of how the data will look in the raw state.

  8. #8
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Re: Adding columns to a macro

    Okay I will in the morning as my computer is at work.

    You could possibly pick it up on the previous thread.

  9. #9
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Re: Adding columns to a macro

    Hi

    Here is the before data that the macro runs from to generate the new sheet.

    Thanks
    Terri
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Re: Adding columns to a macro

    Hi

    Can someone help modify the macro so that in column G instead of the total per driver we have the equation =D26/F26.

    I will need this to happen on each drivers total line in column G

    Thanks

  11. #11
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: Adding columns to a macro

    Should the subtotals be removed? Which sample file can i use?

  12. #12
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Re: Adding columns to a macro

    Hi

    I want subtotals in columns D & F and then the subtotals D divided by F answer in G.
    Attached Files Attached Files

  13. #13
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: Adding columns to a macro

    So you want the subtotal part to be changed in the macro in post 1 right?

  14. #14
    Forum Contributor
    Join Date
    05-31-2012
    Location
    South africa
    MS-Off Ver
    Excel 2010
    Posts
    292

    Re: Adding columns to a macro

    Yes thats correct

  15. #15
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: Adding columns to a macro

    Add this code above the line
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

+ Reply to Thread
Page 1 of 10 1 2 3 ... LastLast

Thread Information

Users Browsing this Thread

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

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