+ Reply to Thread
Results 1 to 2 of 2

Convert Text into multiple rows and search result in next sheet

  1. #1
    Registered User
    Join Date
    04-02-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    1

    Post Convert Text into multiple rows and search result in next sheet

    Hi,

    Could some one help me with a vba script to convert the text in a cell(split considering "Space" as delimiter) into multiple Rows and Single column & the resultant row's(A1:A7000) values need to be searched in Column(B) of another sheet,if the search result is false then the value in the row need to be highlighted in red.

    I am able to split the values in one column into mutiple rows,but need to have all the resultant values in a single column.
    i,e,.

    I am able to split it as below:

    Column A Column B Column C
    A AA A BB
    BB BBAB AA BBAB



    But I want it to be


    Column A Column B
    A AA A
    BB BBAB AA
    BB
    BBAB


    for second situation - search
    I could search based on the values by using Vlookup() function,but unable to highlight when search result is false.

    ex:

    if the search string "ACB" in Sheet1 is not available in the sheet2, then value "ACB" should be changed into red.


    Someone could please help me with your suggestions.

    Thanks in advance...........

  2. #2
    Forum Contributor
    Join Date
    06-22-2011
    Location
    somerset
    MS-Off Ver
    Excel 2016
    Posts
    314

    Re: Convert Text into multiple rows and search result in next sheet

    Please Login or Register  to view this content.
    Last edited by Leon V (AW); 04-11-2014 at 09:54 AM. Reason: Expanded
    Sub Reputation()
    Dim Problem as Variant
    Dim Reputation as Integer
    For Each Problem in Forum.Threads
        If Problem.Title = "*[Solved]*" and Solver.Name = "Leon V (AW)" Then Reputation = Reputation + 1
    Next Problem
    End Sub

+ 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] Search for multiple rows and copy them into a new sheet
    By Moggelito in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-25-2014, 08:50 AM
  2. Search text across sheets and add those rows to a new sheet
    By pjenks in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2014, 02:25 PM
  3. Multiple Criteria search and COUNT FOR TEXT across multiple sheet ARRAY's
    By akaushik25 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-25-2014, 08:58 AM
  4. [SOLVED] Convert text to numbers and move appropriate rows to another sheet.
    By markDuffy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-10-2013, 07:55 AM
  5. Search for Multiple String Values on Multiple Sheets and Copy Rows to New Sheet
    By rrtikker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2012, 12:21 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