+ Reply to Thread
Results 1 to 6 of 6

VBA copies rows based on specific items in a column but need to rename items created

  1. #1
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2003
    Posts
    304

    VBA copies rows based on specific items in a column but need to rename items created

    Hi,

    I'm using excel 2003 and have attached the file complete with the VBA shown below, it works fine except I need it to rename the items in the rows that it's duplicating.

    Please Login or Register  to view this content.
    I hope this makes sense and thanks for any help,

    David
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,824

    Re: VBA copies rows based on specific items in a column but need to rename items created

    Not sure if this is how you wanted.
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2003
    Posts
    304

    Re: VBA copies rows based on specific items in a column but need to rename items created

    Hi jindon thank you but it does not work for the MPL002 which is 3 items instead it creates an additional line with MPL002-3 on it own.
    I have attached the order.xls file with you new code and as you can see it when run it does not create the 2nd line for the MPL002

    Thanks again for your help,

    David
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,824

    Re: VBA copies rows based on specific items in a column but need to rename items created

    OOps,

    Can you change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2003
    Posts
    304

    Re: VBA copies rows based on specific items in a column but need to rename items created

    Perfect! thank you very much for your help.

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,824

    Re: VBA copies rows based on specific items in a column but need to rename items created

    You are welcome.

+ 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