Closed Thread
Results 1 to 4 of 4

Code to search for matching values in two columns, take text from that row and copy

Hybrid View

  1. #1
    Registered User
    Join Date
    03-06-2014
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    83

    Re: Code to search for matching values in two columns, take text from that row and copy

    Okay, thanks

    I've just made a little file to hopefully show what is needed.

    things that the code needs to do:
    1. Identify when Column B changes value, then insert two blank rows above and below
    2. Identify matching values in Column B and C (Task_ID and Parent_task) because the same Task_ID and Parent_task is located in different places in the sheets.
    3. insert "Begin" above the cell in the new blank row in Column C where the values changes
    4. Insert "end" below the cell in column C where the value changes
    5. Copy values from column D-F from matching row in column B
    6. Paste matching values from Column D's into the same row as the new "begin" and "end" Rows.

    Don't know if make sense ?

    So main thing is the identify matching values from Parent_task and Task_ID and the insert two blank rows above and below where the values in Parent_task Column (Column C) changes, and copy the cells from matching column C (but only the columns D-F's cells in the same row as the matching value in column B is.
    Attached Files Attached Files

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 03-14-2014, 06:46 PM
  2. Compare columns and finding matching values/text
    By debake in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-02-2014, 09:27 AM
  3. Code to search for matching text in a table then copy next line
    By douglasm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-27-2014, 12:10 PM
  4. Replies: 0
    Last Post: 10-07-2013, 10:24 AM
  5. [SOLVED] Search for a value in a column and copy row to new sheet for all matching values
    By mrcois in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2012, 12:09 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