Drop down list answer(s) selected to auto appear in another sheet

[rcm4486]

Hi,

I've created a drop down list with a simple 'yes, no, na' for answer options. What I'm trying to accomplish is once someone has selected their answer I would like that answer to auto populate to another cell on another sheet (Master sheet). Does this require VBA, or is it simply a prebuilt function in Excel that would do this for me?

Thanks

[Mumps1]

You may be able to do this with a simple formula or with a macro. It would be easier to help if we could see how your data is organized. Can you post a copy of your file with a detailed explanation of what you want to do referring to specific cells and worksheets?