Results 1 to 8 of 8

Replace specific values in a range with cell value in the same row

Threaded View

  1. #1
    Registered User
    Join Date
    12-18-2012
    Location
    Here
    MS-Off Ver
    Excel 2013
    Posts
    16

    Replace specific values in a range with cell value in the same row

    Hello all,

    Scenario: I have two columns, A & B both filled with values. In column B, there are many cells with "NULL" as their value. I want to write a macro that looks for all instances of "NULL" in the entire range of column B, and replaces them with the value of the cell in the same row as Column A. Thus:

    A B
    1 NULL
    2 Hello
    3 NULL

    would become

    A B
    1 1
    2 Hello
    3 3

    Is there any easy way to do this without a for loop, perhaps a built-in vba function that can do this? Thanks everyone.
    Last edited by HughManatee; 09-13-2013 at 04:13 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to find all specific values in column and replace adjacent cell values
    By dblock02 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2013, 06:03 AM
  2. [SOLVED] Calculate/sum multiple values in each cell in a range then replace with the total of every
    By CharlieAziz in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-03-2012, 11:08 PM
  3. [SOLVED] Return specific values based on the range in another cell
    By AndrewBondarchuk in forum Excel General
    Replies: 3
    Last Post: 11-28-2012, 12:34 PM
  4. Replies: 2
    Last Post: 11-21-2012, 05:59 AM
  5. Open .TXT file Replace Specific Lines with Cell Values
    By Tellm in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-09-2011, 12:08 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