+ Reply to Thread
Results 1 to 4 of 4

Find Matching Cells & copy/paste

  1. #1
    Forum Contributor
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    200

    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

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Find Matching Cells & copy/paste

    You don't need a macro a vlookup or index match formula will work.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Forum Contributor
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    200

    Re: Find Matching Cells & copy/paste

    How do I do that? Thanks.

  4. #4
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    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
    Please Login or Register  to view this content.

+ 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. [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. Replies: 3
    Last Post: 11-26-2013, 04:53 AM
  4. 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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1