Simple Macro that updates cell after making a selection in a drop down list?

I'm creating a form for some guys in our machine shop to use. What I have are drop down list off to the side of the form that will fill in the form. I would like for these to update as they go through selecting them. As all of you know it will only update when I switch sheets. Is there a macro that will run when selecting "A" in the drop down list, that will update the corresponding cell in the form with "A".

Side note, I kept the drop downs off to the side because we have more drop downs than I want on the form. Since I am limited at excel, I was using my drop downs as a process of elimination. May take two drop downs to find one answer.

Thanks for the help guys and gals!

Maybe this isn't as simple as I thought?

Do I need to provide a file example?

I tried shinking the file size down, for whatever reason it was for not. So i'll break it down as simple as I can


On my form I have my sheet that gets filled in, by drop down lists that are off to the right side. All I want is to be able to select an item from my drop down list on the right and it will fill the area with that exact item.

You may be asking why I have the drop down list to the right to fill an item on the left. Well as I stated before, I use a process of drop down lists to narrow down search items to get to the ultimate final answer. So to clean up the form this is the way we proceeded.


Two things.
1. The drop down list selection will work, (1) time on the page on startup
2. It will work if I select the list, go to next sheet, then come back.

The code in the cell that I need the selection from the drop down list to show up in is as followed.....(N16) Is where the drop down list is located.



= IF(ISBLANK('Job Setup Sheet'!N16), "",'Job Setup Sheet'!N16)