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.
HansVogelaar thanks so much for trying to help. i tried that but it didn't work. I've put a link here to the worksheet:
https://letyoungpeopletalk-my.sharepoint.com/:x:/g/personal/niki_powers_lets-talk_scot/EU4XRZM54QpNl6ihEKECAw8BO6CWebzxJAyPprNbzu8M9A?e=mrbwkW
at the moment the values are incorrect and I want to change them so that the correct amount is calculated in the total column
You need a list with the types of work in the first column and the corresponding salary in the second column. I cannot find such a list in your workbook, not even in the hidden worksheets. Am I missing something?
- Hi Again,
I've set up a new worksheet but still can't fix it - how do i make the two lists that you have suggested?- Thanks.
How do I make a formula that then calculates the number of hours at the activity hourly rate ?
- This worksheet was initially set up by someone else - I was just trying to update the pay for each work type - I couldn't find that info either. So perhaps i'll have to start again and set up from scratch.
Thanks anyway