+ Reply to Thread
Results 1 to 6 of 6

VBA Create list of values assigned by condition

  1. #1
    Registered User
    Join Date
    08-21-2014
    Location
    Frankfurt
    MS-Off Ver
    2007
    Posts
    4

    Question VBA Create list of values assigned by condition

    Dear all!

    I turn to you in my darkest hour. Just by reading the title you probably know already that this is a complex problem (at least for me) and hard to summarize in one sentence. So let me explain my problem.

    The scenario is this:
    I have a list of product numbers and product prices (table 1).
    I have a list of those (old) product numbers becoming new ones (table 2).
    BUT some of those products have been merged together so multiple old product numbers have become one new one.

    Now I have a list of the new product numbers and I want to calculate the price of the new product by adding up the price of the old products.

    I attached an excel sheet that might help you to understand my problem.

    Any help or strategy on how to approach this is HUGELY appreciated!
    Attached Files Attached Files

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: VBA Create list of values assigned by condition

    Try this:-
    Results in columns"G & H"
    Please Login or Register  to view this content.
    Regards Mick

  3. #3
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: VBA Create list of values assigned by condition

    hi sk1pjack, non-VBA solution using Pivot table
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: VBA Create list of values assigned by condition

    my solution, no need column G
    Please Login or Register  to view this content.
    If solved remember to mark Thread as solved

  5. #5
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: VBA Create list of values assigned by condition

    another option
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    08-21-2014
    Location
    Frankfurt
    MS-Off Ver
    2007
    Posts
    4

    Re: VBA Create list of values assigned by condition

    Thank you very much! You guys were a great help

+ 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. Create List Based on a Given Condition
    By ExcelFaninPhils in forum Excel General
    Replies: 2
    Last Post: 05-15-2014, 12:15 AM
  2. [SOLVED] Create a list based on whether a condition was met
    By dkrzysik in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-02-2013, 08:08 AM
  3. [SOLVED] Create a list of info from column/row if condition is met
    By QEJohn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-19-2012, 09:43 AM
  4. List of values assigned to list of names
    By Cicada in forum Excel General
    Replies: 8
    Last Post: 08-18-2011, 06:12 PM
  5. Replies: 5
    Last Post: 05-12-2009, 09:37 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