+ Reply to Thread
Results 1 to 4 of 4

Create new table with consecutive numbers when last row from previous table is not blank

  1. #1
    Forum Contributor
    Join Date
    05-01-2018
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    117

    Create new table with consecutive numbers when last row from previous table is not blank

    Hello All VBA Experts

    I got table (as per attached doc.) and I would need a code which will automatically create a new table next to existing one (2 columns after existing table) with the same table headers and consecutive numbers when last row (whichever cell) from previous (current) table is not blank.

    in other words - looking at my spreadsheet I would need a code which will create a new table with consecutive numbers in rage G1:J31 when any last row cells (range B31:D31) in table from range A1:D31 is not blank. And then repeat the same operation when second/third/etc. table meet the same criteria

    please refer to spreadsheet for better understanding of my request:
    when any of last row cells in table (range A1:D:31 excluding first column of the table) is not blank create new table next in range G1:J31 with consecutive numbers in first columns where first number will be next number after last number from previous table (so in this case 30) and then when this table is completed (last row cell is not blank) create another table in range M1:P31, etc....

    is that even possible .......?

    Please note I'm not familiar with VBA at all

    thank you for your help
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-01-2018
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    117

    Re: Create new table with consecutive numbers when last row from previous table is not bla

    Hello All
    is it possible to get some answer on that please?
    thank you

  3. #3
    Forum Contributor
    Join Date
    05-01-2018
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    117

    Re: Create new table with consecutive numbers when last row from previous table is not bla

    Hello
    it seems no one can help?
    thanks

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,259

    Re: Create new table with consecutive numbers when last row from previous table is not bla

    Give this a go...

    Please Login or Register  to view this content.
    Code will run when you enter a value in the last column last row of existing Table etc etc...
    Attached Files Attached Files
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ 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. Replies: 2
    Last Post: 07-23-2018, 12:33 PM
  2. [SOLVED] How do I create a list from a table with no blank cells
    By thedunna in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-20-2017, 10:17 PM
  3. [SOLVED] Help with converting table fields into a new table based on cell blank or not blank
    By BG1983 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-15-2016, 01:00 AM
  4. Pivot table remains linked to table on previous worksheet
    By shmir in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 02-04-2015, 04:46 PM
  5. Excel 2007 : Create a table that lists blank cells
    By cathzee in forum Excel General
    Replies: 0
    Last Post: 10-13-2011, 02:48 PM
  6. Replies: 1
    Last Post: 12-31-2009, 11:13 AM
  7. How to create a table with numbers from 1 to 600?
    By F R A N K in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 06-16-2006, 11:50 AM

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