How to populate cell based on drop-down list attached to the SAME cell?
 

We have a resourcing spreadsheet to track utilization. For each month, I need to assign % FTE based on how long people work on an activity. To increase simplicity, I'd like to use a drop-down list of common times (e.g. 1/2 day, 1 day, 2 days, etc.) and based on the selection, that same cell is populated by the equivalent FTE (e.g. 0.02, 0.05, etc.)

I've toyed with this, but keep getting a 'circular argument' warning. Even after the cell is populated with, say 0.02, I'd like the drop-down list to still exist and allow the user to make a different selection.

I have created my drop-down list using the data validation within excel.

Hi,

What do you gain by using the same cell?

I believe (not tested) there would be a way using VBA, but see little merit in the exercise.

Educo