+ Reply to Thread
Results 1 to 4 of 4

Find Matching Cells & copy/paste

Hybrid View

  1. 12-31-2015, 01:02 PM #1
    backyardfun
    backyardfun is offline
    Forum Contributor
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    206

    Find Matching Cells & copy/paste

    I am looking for a Macro that will help me with a project for year end inventory. I have a list of SKUs in column A with their QOH in Column B. Column D contains a larger list of skus that lists the skus in Column A plus many more irrelevant ones with their ACTUAL QOH in Column E. I need the macro to search column C for a sku that matches the sku in Column A and places (copy/paste) the column E QOH of that matching sku in Column C on the line of the matched sku. I attached a sample spreadsheet that lays it out. I hope this make sense. Thanks.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-31-2015, 01:14 PM #2
    skywriter
    skywriter is offline
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2409
    Posts
    2,789

    Re: Find Matching Cells & copy/paste

    You don't need a macro a vlookup or index match formula will work.
    Reply With QuoteRegister To Reply
  3. 12-31-2015, 01:27 PM #3
    backyardfun
    backyardfun is offline
    Forum Contributor
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    206

    Re: Find Matching Cells & copy/paste

    How do I do that? Thanks.
    Reply With QuoteRegister To Reply
  4. 12-31-2015, 02:40 PM #4
    skywriter
    skywriter is offline
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2409
    Posts
    2,789

    Re: Find Matching Cells & copy/paste

    Put this formula in C2 of your sample sheet and copy it down.

    Good Luck.

    Formula: copy to clipboard 
    =VLOOKUP($A2,$D:$E,2,0)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find matching data, copy data in adjacent cell and paste in new column
    By Bikeman in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-23-2015, 04:08 PM
  2. [SOLVED] Search for multiple matching cells and copy/paste range?
    By papercut in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2014, 11:24 AM
  3. Looking for way to: Copy/Paste range of cells to another worksheet based on matching crite
    By MaryCW in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-26-2013, 04:53 AM
  4. Looking for way to: Copy/Paste range of cells to another worksheet based on matching crite
    By MaryCW in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-25-2013, 09:30 AM
  5. Copy/Paste range of cells to another worksheet based on matching criteria
    By maa50904 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-05-2013, 12:07 AM
  6. How do I find matching values in different wkshts and copy corresponding cells.
    By needexcelhelp23 in forum Excel General
    Replies: 1
    Last Post: 10-27-2009, 03:59 PM
  7. Copy/Paste Certain Cells matching criteria
    By dvs12c in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2009, 11:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1