+ Reply to Thread
Results 1 to 4 of 4

Modify code to duplicate only rows with specific data/value in Column A

  1. 02-17-2015, 09:33 AM #1
    jealoui
    jealoui is offline
    Registered User
    Join Date
    01-14-2015
    Location
    Rhode Island
    MS-Off Ver
    Mac 2011
    Posts
    5

    Modify code to duplicate only rows with specific data/value in Column A

    Hi,
    My macro is duplicating exactly as needed but I only need to duplicate rows that have a specific number in Column A and I can't figure out how to add that condition in. I have three different values that will then need that row duplicated. For example: "KKKKKK" "MMMMM" "NNNNN". Thank you!

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 02-17-2015, 09:54 AM #2
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Modify code to duplicate only rows with specific data/value in Column A

    You may try something like this......

    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  3. 02-17-2015, 10:03 AM #3
    jealoui
    jealoui is offline
    Registered User
    Join Date
    01-14-2015
    Location
    Rhode Island
    MS-Off Ver
    Mac 2011
    Posts
    5

    Re: Modify code to duplicate only rows with specific data/value in Column A

    Thank you that solved it!
    Reply With QuoteRegister To Reply
  4. 02-17-2015, 10:07 AM #4
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Modify code to duplicate only rows with specific data/value in Column A

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Vba code for removing duplicate value from specific column.
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-24-2013, 12:27 PM
  2. Sort by duplicate numbers in rows and if contains specific text in specified column
    By baham in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-03-2013, 05:34 PM
  3. How to modify this Duplicate VBA Code?
    By lifeisaspreadsheet in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-25-2013, 02:34 PM
  4. [SOLVED] Please modify code so it deletes duplicate values in column A
    By Hello23 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-06-2012, 02:13 PM
  5. Modify VBA code to use column data
    By ArtZ in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2012, 03:12 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1