P
pete321
my question/problem is kind of weird but here goes. I'm praying someon
smart and nice with some vba knowledge can help
I'm doing a food data worksheet for my nutrition class
I have five columns per food
quantity, calories. protein, carbs, fat
the foods are also in rows
What i want to do is enter the food data in for each food and then hav
it so later on if i want to change a value in any of the columns, th
rest will move relative to the one
for example, if 1 oz chicken breast is 46 calories, 1 gram fat, 0 carb
9 protein. I can change the protein to be 25 (multiplied by 2.778) th
rest will multipy their current values by 2.7778 automatically.
I talked to some people and heard vba is probably the only way to do i
and i am clueless when it comes to that. Any help with an appropriat
script for what im trying to do would be much appreciated, maybe eve
paypal some bucks over if necessary
thanks in advanc
smart and nice with some vba knowledge can help
I'm doing a food data worksheet for my nutrition class
I have five columns per food
quantity, calories. protein, carbs, fat
the foods are also in rows
What i want to do is enter the food data in for each food and then hav
it so later on if i want to change a value in any of the columns, th
rest will move relative to the one
for example, if 1 oz chicken breast is 46 calories, 1 gram fat, 0 carb
9 protein. I can change the protein to be 25 (multiplied by 2.778) th
rest will multipy their current values by 2.7778 automatically.
I talked to some people and heard vba is probably the only way to do i
and i am clueless when it comes to that. Any help with an appropriat
script for what im trying to do would be much appreciated, maybe eve
paypal some bucks over if necessary
thanks in advanc