+ Reply to Thread
Results 1 to 2 of 2

Copy row n times based on cell value in row, add new column will fill series

  1. #1
    Registered User
    Join Date
    09-11-2003
    Location
    Utah
    Posts
    1

    Question Copy row n times based on cell value in row, add new column will fill series

    I've found some similar solutions, but can't seem to alter them to fit my needs.

    I've got 12 columns of data. The quantity ordered is in the 7th column of data. I want to have the row repeated so there is one row for each item ordered, with a new column inserted in the 8th column to count which row number it is for that order. Some cells may be blank, but not the quantity ordered. I want the copied results in a new sheet.

    Example:
    OrderNum PO ProNum City Mat Desc Qty OrigDate CompDate BOrder ExpDate Notes
    1 A1 46 NYC 46C Tag 3 12/20/2015 01/15/2016
    2 A2 47 NYC 45B Top 2 12/20/2015 01/15/2016

    End Result in new sheet:
    OrderNum PO ProNum City Mat Desc Qty Count OrigDate CompDate BOrder ExpDate Notes
    1 A1 46 NYC 46C Tag 3 1 12/20/2015 01/15/2016
    1 A1 46 NYC 46C Tag 3 2 12/20/2015 01/15/2016
    1 A1 46 NYC 46C Tag 3 3 12/20/2015 01/15/2016
    2 A2 47 NYC 45B Top 2 1 12/20/2015 01/15/2016
    2 A2 47 NYC 45B Top 2 2 12/20/2015 01/15/2016

    advTHANKSance

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Copy row n times based on cell value in row, add new column will fill series

    Maybe :

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. I lost my Copy or fill series choice when coping a cell HELP!
    By Lornawojo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-11-2015, 04:59 PM
  2. [SOLVED] Excel create “bars” or fill series of cells based on other cell value
    By davva23 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-08-2015, 09:16 AM
  3. [SOLVED] Copy Cell to Column X times Based On Cell Value
    By Dess in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-18-2014, 12:13 PM
  4. [SOLVED] Cell Fill based on times
    By paxile2k in forum Excel General
    Replies: 0
    Last Post: 05-16-2012, 06:05 PM
  5. Copy Worksheet X Times Based on Cell Value
    By PY_ in forum Excel General
    Replies: 2
    Last Post: 01-04-2011, 04:10 PM
  6. Replies: 2
    Last Post: 10-27-2010, 12:39 PM
  7. copy sheet a # of times based on cell value
    By nuver in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2005, 03:34 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