+ Reply to Thread
Results 1 to 2 of 2

VBA to replace string as per criteria

  1. #1
    Forum Contributor
    Join Date
    02-13-2014
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    140

    VBA to replace string as per criteria

    Hi,
    I have file where in sheet "edit details", I have list of sheet name, value to be replaced and replacement value.

    need vba to to find sheet name, find the value under column "text to be replaced" and replace the particular value with value metnioned under column "replacement value"

    for example, in sheet2, find value "Row Labels" and replace with value "Name".

    Please note my edit details table rows will increase and decrease time to time.
    Attached Files Attached Files

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,078

    Re: VBA to replace string as per criteria

    This will do it

    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)

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