+ Reply to Thread
Results 1 to 5 of 5

Matching cells and reordering data

  1. #1
    Registered User
    Join Date
    07-03-2016
    Location
    Cayman Islands
    MS-Off Ver
    2010
    Posts
    28

    Matching cells and reordering data

    Hi everyone,

    I am hoping someone can help with what I think needs to be run with a macro.

    I am populating a series of columns from 2 sources that are not in the same order. I need to search a row from 1 source to find a match in the other and if a match is found then take the data from a range of cells and populate elsewhere.

    i have attached a sheet to better explain.

    Thanks,

    Mike
    Attached Files Attached Files

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Matching cells and reordering data

    I did the first one for you. In H6 and copy down;
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Matching cells and reordering data

    Or try in H6:

    =IFERROR(VLOOKUP($A6,$L$6:$O$91,COLUMNS($H:I),0),"")

    Copy across and down.

  4. #4
    Registered User
    Join Date
    07-03-2016
    Location
    Cayman Islands
    MS-Off Ver
    2010
    Posts
    28

    Re: Matching cells and reordering data

    Thank-you for your help

  5. #5
    Registered User
    Join Date
    07-03-2016
    Location
    Cayman Islands
    MS-Off Ver
    2010
    Posts
    28

    Re: Matching cells and reordering data

    Is it possible for this to be performed as a macro so that the empty cells don't have formulas in them?

+ 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. Replies: 11
    Last Post: 05-16-2016, 04:12 PM
  2. Reordering rows based on data
    By larix93 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2015, 04:17 AM
  3. [SOLVED] Reordering Data
    By akboche in forum Excel General
    Replies: 5
    Last Post: 01-09-2015, 03:23 PM
  4. Replies: 5
    Last Post: 12-03-2014, 08:46 PM
  5. pie chart of only the positive values in a table without reordering the data
    By lgjmac in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2013, 10:01 PM
  6. Parsing / Reordering Data for Easy Duplicate Finding?
    By bikeking8 in forum Excel General
    Replies: 2
    Last Post: 04-27-2013, 07:39 AM
  7. [SOLVED] Reordering cells to another sheet
    By MKettu in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-12-2012, 08:08 AM

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