+ Reply to Thread
Results 1 to 3 of 3

Add rows based on cell range

  1. #1
    Registered User
    Join Date
    07-12-2021
    Location
    Aus
    MS-Off Ver
    Newest
    Posts
    2

    Add rows based on cell range

    Capture.PNG

    I am trying to figure out a formula or Excel function to automatically generate new rows based on the range in a cell, and preferably duplicate the dates/other information in other columns stemming from the base row.

    As an example, observe the middle row in the attached image. I need to turn that one row into 144 rows, numbered consecutively from 430925 to 431069, preferably duplicating the date in the same row.

    I've got to do this more times than easily convenient, so I'd prefer it if there was a simple formula a I could use in a blank column to properly expand the range into individual rows, or a tool in excel I could use on the main column.

    I know this is a long shot, but any advice would be great. Cheers.
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Add rows based on cell range

    Using B:C to extract Start-End number

    B3:
    =IFERROR(LEFT($A3,SEARCH("-",$A3)-1)+0,$A3)

    C3:
    =IFERROR(MID($A3,SEARCH("-",$A3)+1,10)+0,$A3)

    Drag all down.

    Assum extract list starts from H3:

    H3:
    Please Login or Register  to view this content.
    Drag down
    Attached Files Attached Files
    Quang PT

  3. #3
    Registered User
    Join Date
    07-12-2021
    Location
    Aus
    MS-Off Ver
    Newest
    Posts
    2

    Re: Add rows based on cell range

    Tahnk you very much. That does a good job of creating the required range. I was hoping it would auto-add and fill the cells below the range in the column, but I think that may be beyond excel's capability.

    Thankfully, I have since discovered that I am not needing to do quite that much since whomever inserted the numbers may have used them in place of a "/" instead. nonetheless, thank you.

+ 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. [SOLVED] Remove empty rows based on a cell range.
    By Christopherdj in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2020, 01:39 AM
  2. VB to delete range in rows based on value of cell
    By MacroNovice18 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2019, 02:25 PM
  3. [SOLVED] VBA - Highlight Range(Rows) based on cell value
    By rxk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2017, 03:01 AM
  4. Select range of rows based on cell value
    By amitmodi_mrt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2017, 08:03 AM
  5. [SOLVED] Hide rows in a named range based on cell value
    By Ravana in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2015, 01:54 AM
  6. [SOLVED] First unhide all rows - then hide rows based on specific cell value for a range of cells
    By robbiekh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-22-2013, 05:46 PM
  7. VBA select cell range based upon the # of rows that make up a certain merged cell?
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-04-2012, 12:22 PM

Tags for this Thread

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