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?
Bookmarks