Hi there,
We've checked the file you sent, we noticed that you didn't expand the dynamic drop-down list range. Which means the range you applied the feature is $H$2:$J$263. To expand the range, please do as follows:
1. On the Kutools tab, click
Navigation. And then click on the icon circled in red as shown below to unhide the hidden worksheets.
2. Delete
List and
List1 as shown below.
3. Go back to
RECIBIDAS sheet. Click on any cell that is in the range
$H$2:$J$263, and then click
Expand Dynamic Drop-down List Range.
4. An Output Range dialog pops up, now select the new range where you want to have the drop-down list. The new range will be filled in the box. Alternatively, you can type in the range directly in the input box, for example,
$H$2:$J$300.
5. Click
OK.
The drop-list is now applied in the new expanded range. If there are any other problems, please don't hesitate to ask me.
Amanda