Drop down menu, need a choice added

**shanshine** · 09-21-2011, 01:02 PM

This is another file that was passed down to me. In the Win Status notes there is a drop down menu which is very helpful but I need an option added. I need DQ added to the list of drop down seletctions.

I went through the steps in help trying to figure out how to do it and I end up messing it up really bad.

Any help would be appreciated!!

**alansidman** · 09-21-2011, 01:33 PM

With your cursor set to the J6, click on the ribbon on the data tab. Select Data Validation then Data Validation again. Your source information will open, add DQ and a comma where you would like this to appear in the drop down. Check the box to apply to all other cells having the same setting.

Alan

**shanshine** · 09-21-2011, 03:56 PM

That was so easy!!!

Thank you! Trying to follow all the steps through excel help was not working for me at all.

**ewongca** · 09-28-2011, 03:19 PM

Hi, I am a excel user and not experience with macro design. I am not sure I submit my question here which is ok for original post. I am appolized if I need to add a new post seperately.
I currently have a report needed to use macro for easy data entry. Not sure someone can help and teach me to design. I have the file draft as attached. Thanks,

**ConneXionLost** · 09-28-2011, 03:37 PM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.