+ Reply to Thread
Results 1 to 8 of 8

Autofill next column row in a table

  1. #1
    Registered User
    Join Date
    06-27-2019
    Location
    UK
    MS-Off Ver
    2010
    Posts
    98

    Autofill next column row in a table

    Hi,

    I have a table with the first column heading named "Quote Nr".

    Please Login or Register  to view this content.
    I want to run this code to add a new row to the bottom of the table and update that row with textbox values on a userform.

    My only problem is the first column of that new row needs to be the next number in the column of that table.

    Column numbers are as follows

    JN-01
    JN-02
    JN-03
    JN-04

    So the next number when I add a new row would need to be JN-05

    anyone any ideas of how this could be done?

    Thanks

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    2010 & 2016
    Posts
    5,360

    Re: Autofill next column row in a table

    Always easier to help on this sort of thing with a sample workbook, but as we do not have one of those I'm guessing here....

    Please Login or Register  to view this content.
    BSB

  3. #3
    Registered User
    Join Date
    06-27-2019
    Location
    UK
    MS-Off Ver
    2010
    Posts
    98

    Re: Autofill next column row in a table

    Thanks very much for your help. I tried this and it worked perfectly!

  4. #4
    Registered User
    Join Date
    06-27-2019
    Location
    UK
    MS-Off Ver
    2010
    Posts
    98

    Re: Autofill next column row in a table

    Sorry I shouldve explained better. This is picking up the row number which wont necessarily be correct. It needs to be "JN-19" then add 1 from the previous row

    eg row 1 could be JN-1937 so the number to the new row will be JN-1937 +1 to get JN-1938

    Would this be simple enough to do?

    Thanks for your help

  5. #5
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    2010 & 2016
    Posts
    5,360

    Re: Autofill next column row in a table

    Quote Originally Posted by colin7 View Post
    Sorry I shouldve explained better. This is picking up the row number which wont necessarily be correct.
    And this is why we ask for a sample workbook.

    Post one of those and we can help further.

    BSB

  6. #6
    Registered User
    Join Date
    06-27-2019
    Location
    UK
    MS-Off Ver
    2010
    Posts
    98

    Re: Autofill next column row in a table

    I have done a quick example

    Thanks
    Attached Files Attached Files

  7. #7
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    2010 & 2016
    Posts
    5,360

    Re: Autofill next column row in a table

    Does this work?
    Please Login or Register  to view this content.
    BSB

  8. #8
    Registered User
    Join Date
    06-27-2019
    Location
    UK
    MS-Off Ver
    2010
    Posts
    98

    Re: Autofill next column row in a table

    BadlySpelledBuoy, This now works perfectly. Thanks for taking the time to help me with this, it's much appreciated!

+ Reply to Thread

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