Thank you for the example. I was trying to see the formula or macro behind how this works, though, and it's not letting me. Can you let me in on how the dropdown and the adjacent cell are linked, specifically, what formula or macro is used? I appreciate your answers.

Sincerely,
derby46a