+ Reply to Thread
Results 1 to 4 of 4

Macro for find and replace columns from one sheet to another

  1. #1
    Forum Contributor
    Join Date
    07-10-2019
    Location
    england
    MS-Off Ver
    2013
    Posts
    423

    Macro for find and replace columns from one sheet to another

    Hi,
    I want a macro for to find and replace from one column to another..
    I want an input from user to ask which column they want to select..
    Then what they want to find..
    if user selects Col D
    and find- "asd"
    then replace column -Col F
    replace word- "dfg"

    Then i want to find asd in the column.. it can be a full word or part of the cell ..
    After that i want to replace in Col F..

  2. #2
    Forum Contributor
    Join Date
    07-10-2019
    Location
    england
    MS-Off Ver
    2013
    Posts
    423

    Re: Macro for find and replace columns from one sheet to another

    Can anyone help?

  3. #3
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,503

    Re: Macro for find and replace columns from one sheet to another

    Is the replace column always Column F or is the user supposed to select which column to do the replacements in?

    I am guessing the user should specify which word to replace as well, correct?

    Are the find and replace words to be case sensitive or not? That is, if the find word starts a sentence so that it is "Asd", should that match the specified word "asd"?

  4. #4
    Forum Contributor
    Join Date
    07-10-2019
    Location
    england
    MS-Off Ver
    2013
    Posts
    423
    Quote Originally Posted by Rick Rothstein View Post
    Is the replace column always Column F or is the user supposed to select which column to do the replacements in?

    I am guessing the user should specify which word to replace as well, correct?

    Are the find and replace words to be case sensitive or not? That is, if the find word starts a sentence so that it is "Asd", should that match the specified word "asd"?
    Hi Rick,
    I have only small words in the column.. so no case sensitive issue..
    Yest the input column find and replace both is to get from the user. And words both for find and replace also user input..

+ 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. Replies: 3
    Last Post: 11-25-2014, 06:08 AM
  2. Add work sheet, find and replace macro help!
    By Snaybot in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-13-2014, 01:36 PM
  3. Find and replace but replace value of cell 3 columns along
    By batchjb69 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2014, 10:57 AM
  4. [SOLVED] Find and Replace Macro- Within Workbook or Sheet
    By Rhudi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-14-2013, 12:53 PM
  5. Run Time Error '6' Overflow - Macro That Find Text and Copy Range & Replace on Other Sheet
    By asgharhussaini in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-17-2013, 04:34 AM
  6. [SOLVED] Find and Replace Macro not working for sheet Referance in formula
    By Lotrking1010 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-31-2012, 08:15 AM
  7. Find and replace columns with others of another sheet
    By Costasg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2011, 11:32 AM

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