Results 1 to 2 of 2

Thread: Search for a value in a column and copy row to new sheet for all matching values

  1. #1

    Search for a value in a column and copy row to new sheet for all matching values



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Greetings All,

    I have been working on a macro that allows me to search for a value in a column and copy the row with matching values to a new sheet.

    Unfortunately, the raw data i have present doesn't allow the macro to fully function and i need some guidance with resolving this issue.

    The current macro only identifies and copies cells with a single value. However my raw data has several options codes within a cell.


    Is it possible to modify the following formula to identify a specific value within a range of values? If Range("D" & CStr(LSearchRow)).Value = Range("C1") Then

    If else should i split the options to separate cells? If that's the case how do i expend the current range from "D" to "D","E","F"?

    Truly appreciate your assistance!

    Thank you in advance,
    Gopi
    Attached Files Attached Files

  2. #2
    Excel 2010 with free Power Query Add-In.
    Compatible with Office 2013 Pro Plus.
    No VBA macro, no $A$1 type formulas.
    With Select, Split, Merge, and UnPivot Columns.
    http://805fbd0dee7e8ba6e8e2-24c8ffd6...02_13_15a.xlsx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •