+ Reply to Thread
Results 1 to 2 of 2

Find and replace but replace value of cell 3 columns along

  1. #1
    Forum Contributor
    Join Date
    01-16-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    136

    Find and replace but replace value of cell 3 columns along

    Hi,

    I have the below code but instead of replacing the actual lookup value I wish to replace the value of a cell 3 columns along from the lookup value and on the same row. if the lookup value is found. How would I adjust the below

    [CODE]
    With Sheets("Joined")
    Set rngData = .Range("V2", .Range("V" & Rows.Count).End(xlUp))
    End With

    With Sheets("Funds")
    Set rngLookup = .Range("A1", .Range("A" & Rows.Count).End(xlUp))
    End With

    For Each Lookup In rngLookup
    If Lookup.Value <> "" Then
    rngData.Replace What:=Lookup.Value, _
    Replacement:=Lookup.Offset(0, 3).Value, _
    LookAt:=xlWhole, _
    SearchOrder:=xlByRows, _
    MatchCase:=False
    End If
    Next Lookup

    [\CODE]

  2. #2
    Forum Contributor
    Join Date
    01-16-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    136

    Re: Find and replace but replace value of cell 3 columns along

    Hi,

    I have the below code but instead of replacing the actual lookup value I wish to replace the value of a cell 3 columns along from the lookup value and on the same row. if the lookup value is found. How would I adjust the below

    Please Login or Register  to view this content.

+ 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: 0
    Last Post: 02-01-2014, 09:52 AM
  2. [SOLVED] find and replace to not replace characters found as wildcards
    By sabutler4 in forum Excel General
    Replies: 4
    Last Post: 07-03-2013, 06:48 PM
  3. Multiple Find and Replace to replace a list of strings
    By WalterP34 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-11-2011, 07:41 PM
  4. Find, Replace with and then replace adjacent cell
    By Craig2097 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2009, 12:42 PM
  5. find and replace - replace data in rows to separated by commas
    By msdker in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2006, 08:10 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