Auto Populate Multiple Cells Based On One Drop Down

Dear Friends,

Can anyone guide me how to prepare the enclosed excel sheet with dropdown icons.

In the enclosed file only one drop down icon (+ sign) is created below formula bar to open multiple cells. I want to learn how this drop down (+ sign) is created below formula bar to open multiple cells. I have searched it in google also, but I didn't find anything.

Thanks you very much in advance.
Regards
M

http://www.excelforum.com/excel-gene...ml#post3839259

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.