+ Reply to Thread
Results 1 to 7 of 7

add a new row to the bottom of the table

  1. #1
    Registered User
    Join Date
    02-03-2015
    Location
    Larvik, Norway
    MS-Off Ver
    Office MAC 2011
    Posts
    43

    add a new row to the bottom of the table

    Hi

    I need som help to get at button to "add a new row." The row need to bee added at the end of the table.
    And the sheet has different number of rows each month.

    And colom C and D is merged together and they need to bee that in the new row to.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: add a new row to the bottom of the table

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    02-03-2015
    Location
    Larvik, Norway
    MS-Off Ver
    Office MAC 2011
    Posts
    43

    Re: add a new row to the bottom of the table

    Thank you AlphaFrog.

    I got it to work.

    It sums up from I-M at the bottom. Is it possible to include this when adding a new line? So that the new row are also summed correctly to the total?
    Last edited by magic2finger; 02-14-2018 at 04:12 PM.

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: add a new row to the bottom of the table

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    02-03-2015
    Location
    Larvik, Norway
    MS-Off Ver
    Office MAC 2011
    Posts
    43

    Re: add a new row to the bottom of the table

    Did som adjustment on the table. The rows are merged together 3 and 3 rows. How to I get the new added line to be 3 lines merged together?

    Thanks for all the help I really appreciate it!

  6. #6
    Registered User
    Join Date
    02-03-2015
    Location
    Larvik, Norway
    MS-Off Ver
    Office MAC 2011
    Posts
    43

    Re: add a new row to the bottom of the table

    Someone? Pleas

  7. #7
    Registered User
    Join Date
    02-03-2015
    Location
    Larvik, Norway
    MS-Off Ver
    Office MAC 2011
    Posts
    43

    Re: add a new row to the bottom of the table

    Is it possible ?

+ 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. Add data to bottom of table
    By oskar.dlugolecki in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2017, 07:39 AM
  2. How to select all without going to bottom of table
    By ammartino44 in forum Excel General
    Replies: 4
    Last Post: 11-10-2014, 10:41 PM
  3. Help with VBA code to find bottom row in pivot table and fill table cell borders
    By Eric111 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2014, 07:15 PM
  4. Add a table to the bottom of a table using a macro
    By bukkibams in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2013, 11:39 AM
  5. need get a table to automatically add a row at the bottom of the table with the format
    By ryan oconnor in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-22-2012, 03:32 AM
  6. Replies: 3
    Last Post: 03-26-2008, 07:34 PM
  7. Run A Macro Against a Table Until it gets to bottom
    By racer25 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-04-2005, 12:22 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