Combo box not showing full list

Go to Formulas, Name Manager, and click on tblEmployees. Update the range from CALCULATIONS!$A$2:$A$92 to be this formula:

Formula:

=OFFSET(CALCULATIONS!$A$3,0,0,COUNTA(CALCULATIONS!$A:$A),1)

This formula will always capture all the employees in the list no matter how many are added or removed.

Go to Developer, click on Design. Right click on each of your comboboxes and set the ListFillRange property to be tblEmployees.

Now you have a dynamic range to list employees and every place that needs to refer to that list is using the same range.

These seemed to be locked somehow