Forum Discussion
Solved
giving a drop down list item a value
So I have an excel timesheet which has a drop down list where people can select what kind of work they were doing ( either 'training', 'worker' or 'organiser'). Each of these categories has a differ...
https://www.freecodecamp.org/news/excel-vba-tutorial
press Alt+F11
try to modify below codes to change rates.
yHansVogelaar yes I did that but couldn’t change the amounts or see where the figures used in the formula are. Am gonna try a different type of formula.
where the figures used in the formula are.
In column J
range J4
=ratecalc(I4,H4)
In column J
range J4
=ratecalc(I4,H4)
- You are welcome.
- AMAZING - thank you SO much - that worked. I would never have found that or known how to do that. thanks for your help!
https://www.freecodecamp.org/news/excel-vba-tutorial
press Alt+F11
try to modify below codes to change rates.
- I can see the formula but I can’t see how to change the rate amounts - the formula currently uses the old rate amounts to create the total amount but I need to update the rate amounts - but can’t see how to do this