Need to access certain elements in a drop down list and return values from another cell

So I have a drop down list on a sheet, of approximately 200 elements. The drop down list is in cell B3 in sheet 2.

I'd like to write some VBA that selects particular elements of the drop down list that I choose (28 in all). For example, I would like the code to choose "Operating Margin" from the dropdown list, and then return values from other cells on that sheet (say, E5, F6, G7) to a different worksheet in the workbook.

Then, I would like the code to chose "Gross Margin", for example, and return the same values as above, for 28 items in all.

I'm stuck on getting the VBA to be able to choose from the drop down list. I'm not very experienced with VBA, any help would be appreciated!

Originally Posted by Norie

Why do you need to choose from the dropdown list?

How is that getting the values you want?

Picking "Operating Margin" effects changes in financial calculations based on a database of financial data. It returns the operating margin (or one of the other 27 metrics I'd like to choose) for a number of different companies, as well as weighted averages and interquartile ranges for all the companies. I want the code to loop through these 28 metrics and return certain values to another sheet.

I hope that helped. I'm not sure how to get the code to choose an element from the list, but not pick all the elements form the dropdown.

Originally Posted by Norie

Can't you just plug in the value to the appropriate cell instead of picking it from the list?

That is of course if the dropdown is linked to a cell which is used to drive the calculations.

It is the case that the dropdown is linked to another cell which drives the calculations. This is part of a complicated financial model that derives its data from an online source, so it is dynamic on a number of levels. I also had no part in constructing this model, which makes it difficult to explain.

The dropdown choices are linked to a number of cells on different sheets which hold data. These data are calculated together to return the final result, which is displayed below the drop down. Each choice in the dropdown is linked to different cells as well.

I appreciate you taking time to walk me through this, I may not be explaining my problem well.