+ Reply to Thread
Results 1 to 5 of 5

How can I locate all cells with the same value and place specific text in adjacent cells

  1. #1
    Registered User
    Join Date
    02-03-2012
    Location
    Buffalo, NY
    MS-Off Ver
    Excel 2003
    Posts
    6

    How can I locate all cells with the same value and place specific text in adjacent cells

    I need a way to select a cell in a column, find all the cells with the same value, and place specific text in adjacent cells next to each of them.
    For example, I select "Rite Aid" and for all cells containing "Rite Aid" I want to fill the cell next to it with "Prescriptions".
    I'm brand new to Excel and I'm using the version that comes in Office 2010.
    Please tell me what to do and how to implement it.

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: How can I locate all cells with the same value and place specific text in adjacent cel

    Try running this macro.

    In your Excel worksheet, press Alt + F11, this will open up the VB editor.
    Press Ctrl + R to open up the Project explorer, displayed on the left by default.
    Look for your workbook name, right click on it and Insert -> Module.
    Now paste below code into the empty module window to the right side.
    Go back to Excel worksheet, select the cell you wanted to find.
    Press Alt + F8, to open up the macros window.
    You should be able to see FindCellsPlaceText in there, run it.


    Please Login or Register  to view this content.
    多么想要告诉你 我好喜欢你

  3. #3
    Registered User
    Join Date
    02-03-2012
    Location
    Buffalo, NY
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: How can I locate all cells with the same value and place specific text in adjacent cel

    yes, excellent. .thank you!

  4. #4
    Registered User
    Join Date
    02-03-2012
    Location
    Buffalo, NY
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: How can I locate all cells with the same value and place specific text in adjacent cel

    is there a way to mod it so that I'm prompted for the text (ie: Prescriptions) by way of a text box, rather than changing the actual code each time?

  5. #5
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: How can I locate all cells with the same value and place specific text in adjacent cel

    Right, sorry I did not get an email notification of your last post, so I missed it somehow.

    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. [SOLVED] Counting Specific Text Occurences in Cells Adjacent to Particular Values
    By lowlybroker in forum Excel General
    Replies: 7
    Last Post: 10-21-2013, 12:07 PM
  2. [SOLVED] [How] Place Horizontally Adjacent Cells in Vertical Format
    By chocochoco in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-17-2013, 06:00 PM
  3. [SOLVED] Scan cells, locate a certain text and add the adjacent cell
    By randomintel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-17-2013, 10:24 AM
  4. Replies: 7
    Last Post: 12-04-2012, 06:23 AM
  5. Replies: 4
    Last Post: 05-12-2011, 04:37 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