+ Reply to Thread
Results 1 to 6 of 6

Replacing values from a Cell by Reference values

  1. #1
    Registered User
    Join Date
    03-05-2018
    Location
    japan
    MS-Off Ver
    2016
    Posts
    1

    Replacing values from a Cell by Reference values

    Hello

    Is it possible to replace multiple comma separated values in excel cell by values in reference column?

    Please refer the attachment.

    Example
    If I type A2, A5 in cell C2 then it should replace the value as Apple, Dog.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Replacing values from a Cell by Reference values

    To Sheet1 code module
    Please Login or Register  to view this content.

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Replacing values from a Cell by Reference values

    I guess, code proposed by Jindon can be used like this...
    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Replacing values from a Cell by Reference values

    Please Login or Register  to view this content.
    Not good enough

    e.g
    xxx100000000000000000000000

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Replacing values from a Cell by Reference values

    If you want to restrict to A2:Ax, this should be good enough
    Please Login or Register  to view this content.
    Last edited by jindon; 03-05-2018 at 06:02 AM.

  6. #6
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Replacing values from a Cell by Reference values

    this activates userform if any cell in column C is selected

    Please Login or Register  to view this content.
    Kind regards
    Leo

+ 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. replacing cell values with their corresponding ASCII code
    By Lmadahali in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-27-2014, 09:58 AM
  2. replacing cell values with their corresponding ASCII code
    By Lmadahali in forum Excel General
    Replies: 1
    Last Post: 10-16-2014, 06:23 PM
  3. Replacing cell values
    By wjk221 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-06-2014, 04:58 PM
  4. Replies: 1
    Last Post: 10-01-2013, 02:41 AM
  5. replacing cell values
    By abhimaan in forum Excel General
    Replies: 1
    Last Post: 05-26-2012, 06:58 PM
  6. Replacing matched cell values
    By los7 in forum Excel General
    Replies: 4
    Last Post: 06-09-2009, 01:54 AM
  7. Replacing Linked Cell Values w/ Current Values
    By TomCat in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-10-2006, 07:25 AM

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