+ Reply to Thread
Results 1 to 3 of 3

looking for VBA code to return a value in a single cell of the sum of cells with matching

  1. #1
    Registered User
    Join Date
    05-14-2014
    MS-Off Ver
    Excel 2013
    Posts
    15

    looking for VBA code to return a value in a single cell of the sum of cells with matching

    looking for VBA code to return a value in a single cell of the sum of cells with matching criteria.

    Attached is a workbook that I get pulled from our POS system. I have deleted 1300 rows to cut on clutter and to use as sample data.

    I have 2 tabs, "What I get" and "What I need". next to each part number is a quantity for a specific order. Some parts are listed several times but I need only one value for that Part Number. I want to go through the list of orders and find out how many total parts are ordered and return a value in the last column "Notes" next to the first record listed and empty cells for the rest of the rows with the same Part Number.

    I have a function that I have put together to get the report to look like the "What I get" tab and would like to add this last piece of code to finish the project.

    Thanks in advance

    Sample.xlsm

  2. #2
    Valued Forum Contributor
    Join Date
    09-01-2013
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    324

    Re: looking for VBA code to return a value in a single cell of the sum of cells with match

    This can be done but first have you thought about using a pivot table for this? See the attached:

    Otherwise see my other alternatives below this message.
    Attached Files Attached Files
    Last edited by playaller; 05-20-2014 at 05:50 PM.


    Shelton A.
    If Helpful, Add Reputaion!

  3. #3
    Valued Forum Contributor
    Join Date
    09-01-2013
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    324

    Re: looking for VBA code to return a value in a single cell of the sum of cells with match

    If you need a Macro, use the code below:

    Please Login or Register  to view this content.

    Also Optionally you can use the manual formula method by putting the below formula in E2 and dragging down:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by playaller; 05-20-2014 at 05:49 PM.

+ 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] from matching numbers in one column return value of second cells in another cell
    By Rob69mfj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2014, 08:23 AM
  2. Replies: 5
    Last Post: 04-24-2014, 11:24 AM
  3. Matching a single cell to multiple cells
    By jsp01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-24-2013, 02:50 AM
  4. Replies: 10
    Last Post: 05-21-2013, 12:58 AM
  5. Replies: 0
    Last Post: 08-23-2012, 01:43 PM

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