I have a workbook in which staff members input their days worked on one tab. On a separate tab, they choose expense categories from drop-down menus that automatically calculate expenses.
It works fine if they input their hours first and then pick the expense category. However, if they then go back and change their hours worked, the expenses on the other tab do not recalculate unless they reselect the expenses.
Is there any way to add a line to the code so it recalculates when changes are made on the hours worked tab?
Attached is an example workbook. You can see how initially the 10 days worked for employee A results in $390 printing expenses on the other tab. But, if you then change it to 5 days worked, the printing expenses remain $390 unless you relesect "Printing" from the drop-down menu.
Below is the code on the expense page.
Thanks in advance.
Bookmarks