Hi there,



This is probably a very simple problem but I suppose i'm not sure what I'm asking and so have had troubles finding it through google.

What I would like to do is create a drop down menu that will then set formulas in accordance to the selection.

I have several metrics I use to evaluate performance, CPM, CPV, CPC, etc. What I want to do is make it very simple by selecting CPM for example and then it will set up that row with all the formulas to work out CPM and other relevant metrics related to CPM.

Hypothetically it would work by having the drop box menu in B1 then information would be in cells B2:B7 and then a formula in B8 using the relevant information in B2:B7 to calculate the CPM (or whichever metric has been selected).

Hopefully this is clearly explained. Any help would be greatly appreciated.

Many thanks,

Rich

Could you please post a small sample sheet showing your data and expected results ( click Go advanced Manage attachments)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks for your response.

I have tried to set up a basic sheet of data as per your request, not sure if it's exactly what you were after.

But what I would like to know is how to make that CPV/CPC/CPM available from a dropbox, similar to the Live status to the left of it.

After selecting CPM for example, the rest of that row would then be formatted as per the sheet.

Cheers,

Attached Files

EXample.xlsx (12.0 KB, 11 views)