+ Reply to Thread
Results 1 to 2 of 2

I have two combox's drop down, how would i populate data on the sheets?

  1. #1
    Registered User
    Join Date
    04-04-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    27

    I have two combox's drop down, how would i populate data on the sheets?

    I have two combox's drop down, i was wondering how can i populate data on the sheets without too many ifs in my code? I have countries and industries and i want to populate sales based on country and industry but i do not want to write a long code saying if countries = 1 and industries = 1 then this, if countries = 1 and industries = 2 then this, etc... (numbers as in cell link). I am sure there is a more efficient way to do this, i just cant think of any. I am also planning on populating the data based on a cell change through vba...not sure if that is the most efficient way as well?

  2. #2
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: I have two combox's drop down, how would i populate data on the sheets?

    depending on your dataset you can probably use sumproduct to do this pretty neatly. can you upload a sample?

    it will look something like this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    where dataset is a worksheet with information aligned in columns, countries, industries and sales figure are the column reference (i.e. A:A, B:B) corresponding to that information and dropdown# is a cell reference where the dropdowns are located (i.e. A1, A2)
    Last edited by simarui; 08-05-2014 at 03:48 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. User Form combox populate from hidden workbook
    By jprlimey in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-27-2014, 11:33 AM
  2. How to use drop down menu to populate data to other sheets
    By andy.k in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-06-2013, 08:59 PM
  3. [SOLVED] Populate Table with data from other sheets based on drop down selection
    By nhen.enry in forum Excel - New Users/Basics
    Replies: 13
    Last Post: 09-06-2012, 10:54 PM
  4. Drop down menu to populate multiple sheets
    By jerrett in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-12-2012, 09:01 AM
  5. Can I populate a combox with data using one of the properties
    By rkjudy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2011, 04:23 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