+ Reply to Thread
Results 1 to 2 of 2

How to insert a duplicate row with specific text, and make change to the new row?

  1. #1
    Registered User
    Join Date
    09-05-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    2013
    Posts
    10

    Question How to insert a duplicate row with specific text, and make change to the new row?

    Please see the sample attached. I want to duplicate the row with text "NONPEN", and change the word "NONPEN" on duplicated row to "MEMBER".

    Can someone show me how to do this?

    I did some search:

    https://www.youtube.com/watch?v=-PvxzYAZQPo

    But this does not apply to my situation, and it seems too complicated.
    Attached Files Attached Files

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

    Re: How to insert a duplicate row with specific text, and make change to the new row?

    Maybe :
    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

+ 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] Look for specific text string, insert row below, insert text to that row
    By jwats in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-19-2015, 03:08 PM
  2. [SOLVED] Insert todays date but make sure it doesn't change
    By smash96 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2014, 04:16 AM
  3. [SOLVED] How to insert row above specific text
    By KazigluBey in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 07-12-2013, 12:22 PM
  4. Make ranges in a sort macro change when I insert rows
    By Paul Sheppard in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-07-2012, 08:57 AM
  5. How do I make my macro insert/paste code in specific column range?
    By Rabbitstew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2012, 04:33 PM
  6. Finding specific text then insert a row
    By emina002 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2011, 04:22 AM
  7. macro to insert row after specific text
    By Luke in forum Excel General
    Replies: 2
    Last Post: 09-19-2005, 12:05 PM

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