Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Location
    St. Louis, Missouri, USA
    Posts
    67
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Add totals below last row via macro

    Iím importing data from a .csv file into Excel and cleaning it up. I recorded a macro, as Iím not fluent in Visual Basic (not even tourist VB). Most of the things the macro does are formatting and search and replace.

    What I would like to do is to add a Totals row under each column. The number of rows can change whenever itís run; is there a way to automatically add the sums after whichever row is the last one?
    And is there a way to do this without Visual Basic?

    Attached is a small sample. Right now the macro adds totals, but only in a specific row.
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    This is such a frequent issue, and one that's complex to solve in the way you put it.

    If you don't mind me slightly changing the question . . . to get a quick and simple solution, which is what I think you are looking for, just put the total at the TOP of the column instead of the bottom, and make the sum extend beyond the largest amout of data you think you'll get.

  3. #3
    Star Lounger
    Join Date
    Aug 2001
    Location
    St. Louis, Missouri, USA
    Posts
    67
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks, MartinM. I was hoping I had just overlooked something simple.

    It seems that all of my Excel problems start with, "You'd think this would be really simple, . . . "

Posting Permissions

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