Results 1 to 10 of 10

Duplicate Line and Replace word

Threaded View

  1. #1
    Registered User
    Join Date
    07-25-2019
    Location
    CA
    MS-Off Ver
    365
    Posts
    10

    Duplicate Line and Replace word

    Hello, I have a file that has a sentence on one row and a second tab with find/replace words. I am hoping through VBA or something similar I could run a tool that would review my file (approx 50,000 lines) and if the word in Column 1 is present, it would duplicate the row x times, depending on how many replace words there are and change the word in the sentence. Attached is a very simple sample file of what I am trying to accomplish.

    Example:
    Sheet 1: The Cat jumped over the Dog

    Sheet 2:
    Find / Replace With
    Dog / Frog
    Dog / Turtle
    Dog / Pig
    Dog / Horse

    Sheet 3:
    The Cat jumped over the Dog
    The Cat jumped over the Frog
    The Cat jumped over the Turtle
    The Cat jumped over the Pig
    The Cat jumped over the Horse

    Thanks for any help you can offer!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to duplicate a line but replace data in cells from a comment column
    By Kalamari in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-26-2021, 09:30 AM
  2. Replies: 4
    Last Post: 10-21-2020, 11:42 PM
  3. [SOLVED] Excel to Word Find and Replace changes line spacing.
    By pichon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2018, 12:47 AM
  4. Excel VBA - Word to search for part of a word and replace full word
    By charlie543 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-24-2016, 02:56 AM
  5. If line is 'Checked' replace line in Original data...... PLEASE HELP :(
    By evansmike881 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2016, 10:09 AM
  6. [SOLVED] Help with macro to find a specific word and replace the entire cell with the return word.
    By BG1983 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 08-24-2015, 09:40 PM
  7. Replies: 1
    Last Post: 01-26-2012, 10:06 AM

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