Results 1 to 6 of 6

Find and Replace Macro Based on Specific Cells

Threaded View

  1. #1
    Registered User
    Join Date
    09-12-2009
    Location
    United States
    MS-Off Ver
    Excel 2019
    Posts
    7

    Find and Replace Macro Based on Specific Cells

    Hello all. After much fretting over this (and many other Excel issues), I've decided to seek out some assistance. I've included an example with columns, because I'm not very fluent in Excel terminology.

    Worksheet 1
    
    	1	        2
    A	Able	        Apple
    B	Baker	        Bacon
    C	Charlie	        Chicken
    D	Delta	        Duck
    
    
    Worksheet 2
    
    	1	         2
    A	Alpha	        Apricot
    I want to create a macro that will take the text from A1 on worksheet 2, find that text on worksheet 1, then replace A2 on worksheet 1 with A2 on worksheet 2.

    In other words, I want the macro to (in this example), find "Alpha" in worksheet 1, then replace "Apple" on worksheet 1 with "Apricot" from worksheet 2.

    Apologies if this is not clear: I'm still having trouble expressing myself when it comes to Excel.
    Last edited by EvoDE; 09-12-2009 at 07:42 PM.

Thread Information

Users Browsing this Thread

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

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