I am trying to fill a series of cells from a dropdown box which refers to named range in a different worksheet within the same workbook. The values of the range are subject to change based on other variables and I want the end-use cells to vary as the range values change. In the attached demo sheet, On the worksheet "Labor" I want the values to change when the inflation escalators on the worksheet "Assumptions" change the labor rates in the named ranges on the worksheet "Assumptions."
What actually happens is that when the range changes, then the selections in the dropdown change, but not the actual values in the fields, meaning my projections don't flow through the entire workbook properly.
Any suggestions are welcome
Bookmarks