Results 1 to 4 of 4

Find and return corresponding first matching value found + transpose data

Threaded View

mgcarino14 Find and return corresponding... 02-13-2017, 09:48 AM
jindon Re: Find and return... 02-13-2017, 10:47 AM
mgcarino14 Re: Find and return... 02-13-2017, 11:05 AM
jindon Re: Find and return... 02-13-2017, 11:15 AM
  1. #1
    Registered User
    Join Date
    10-31-2014
    Location
    Albany, New York
    MS-Off Ver
    2010
    Posts
    32

    Find and return corresponding first matching value found + transpose data

    Hi Experts!
    I need help with writing a VBA code that will transpose data from Sheet A (UniqueItem), and finds the matching first level reaction from Sheet B (Cards) for each card, and return output on another sheet (Output).
    There are 3 level reactions allowed for each item, but only the first matching reaction found in the card needs to be returned.
    See attached excel file for data and expected output.
    Attached Files Attached Files
    Last edited by mgcarino14; 02-13-2017 at 11:06 AM. Reason: Solving Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 27
    Last Post: 06-06-2014, 05:30 PM
  2. [SOLVED] Macro to find every employee id found in column B and paste on matching row
    By walkingwill in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-18-2013, 11:15 AM
  3. Replies: 2
    Last Post: 04-11-2013, 11:14 AM
  4. Replies: 1
    Last Post: 02-21-2013, 05:49 PM
  5. Search to find matching cells and copy/transpose adjacent data to original sheet?
    By thump4r in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-12-2009, 09:20 PM
  6. find matching value and return data from previous column
    By mheinmiller in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2009, 12:36 PM
  7. find name; search column; if date found-return 3 data pts; move to next row
    By cdl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2008, 10:43 AM

Tags for this Thread

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