Results 1 to 4 of 4

Find Matching Cells & copy/paste

Threaded View

backyardfun Find Matching Cells &... 12-31-2015, 01:02 PM
skywriter Re: Find Matching Cells &... 12-31-2015, 01:14 PM
backyardfun Re: Find Matching Cells &... 12-31-2015, 01:27 PM
skywriter Re: Find Matching Cells &... 12-31-2015, 02:40 PM
  1. #1
    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

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