Creating a percentage drop down list to change the values of a number of cells

[shmit88]

I've had a good look on Google but cannot find anything similar to what I require, so I hope there's a solution.

I have a list of foods on a spreadsheet, each food has their nutritional values to the right of them,

so for instance, A1 = Food Name, B1 = Grams, C1 = Calories, D1 = Protein, E1 = Carbs and F1 = Fats.

Looks similar to this:

Blueberries 50 60 1 14 0


I'd like their to be a percentage dropdown list in between the grams and calories which affect the values of all the other cells (excluding food name). i.e. a dropdown list from 10% to 100%. So with the above example it would look like this:

Blueberries 25 50% 30 0.5 7 0


What is the best form to use and could someone possibly point me in the right direction of the VBA code?

I'm doing my best to learn the basics but this is beyond me.

Thanks.


Calum

[daffodil11]

Maybe something utilizing data validation dropdown menus?

You would first need to store the base information somewhere else, such as on another tab. Then using vlookup you can reference the data and slide its values based on the dropdown percentage.

See attached