+ Reply to Thread
Results 1 to 2 of 2

Macro to Perform Find and Replace Function Please HELP!

  1. #1
    Registered User
    Join Date
    07-11-2013
    Location
    Long Island, NY
    MS-Off Ver
    Excel 2010
    Posts
    36

    Question Macro to Perform Find and Replace Function Please HELP!

    I have searched for this and came across many posts but none seem to work. I have two sheets. One is named sheet1 where all my data is and sheet2 where all my values are. I want to do a find a replace on column N (sheet1) using the data in sheet2. Column A on Sheet2 has all the values that are found in column N and column B on Sheet2 has what the data should change to.

    So for example:

    Sheet1 says the following on column N:

    cat
    dog
    lion
    bear

    Sheet2 says:

    Column A
    A1: Cat
    A2: Dog
    A3: Bear


    Column B
    B1: 2
    B2: 8
    B3:15

    I want the values on column N to be replaced with 2, 8, 15 and so forth. I use excel 2010. Thanks in advanced for your help!!!

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Macro to Perform Find and Replace Function Please HELP!

    Why is it a search and replace and not just a copy and paste?

    Also post a sample workbook next time instead of describing your data, that gets much more of a response from the board.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ 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. Perform Find-and-replace on clipboard before pasting
    By adykhu55 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-17-2014, 05:52 PM
  2. VBA code to find duplicate cells in a column, then perform a function
    By under00c in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-07-2013, 08:19 AM
  3. Replace variables in string and perform function
    By Jefferson in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-02-2012, 07:53 PM
  4. Advanced Find and Replace function or macro help
    By johnmalcolm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2007, 11:01 PM
  5. [SOLVED] Perform Row Function Using Macro
    By mvyvoda in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2006, 02:50 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