+ Reply to Thread
Results 1 to 5 of 5

Auto Populate Multiple Cells Based On One Drop Down

  1. #1
    Registered User
    Join Date
    09-17-2014
    Location
    india
    MS-Off Ver
    2010
    Posts
    2

    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
    Attached Files Attached Files
    Last edited by meenukekhushi; 09-19-2014 at 03:42 AM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,116

    Re: Excel formula

    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.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,833

    Re: Excel formula

    Hi,

    You data is not enough to explain what you are trying to achieve ,
    Explain in details what to to be happen & where should it be happen

    Punnam

  4. #4
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,833

    Re: Auto Populate Multiple Cells Based On One Drop Down

    Hi meenukekhushi ,

    This is called Grouping this can be done to Either to column or Rows .
    Check the Outline Tab in Data Tab .
    Select the required Column & Click Group to UN group the same use "Un Group" TAB.

    To view or hide use the + Sign
    Punnam

  5. #5
    Registered User
    Join Date
    09-17-2014
    Location
    india
    MS-Off Ver
    2010
    Posts
    2

    Re: Auto Populate Multiple Cells Based On One Drop Down

    Hi Punnam,

    Thank you very much to solve the query. I was not aware about Grouping function.

    I tried this and working properly

    Thanks & Regards
    M

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 03-21-2014, 11:43 AM
  2. Macro: Applying formula to multiple cells in excel (formula editing)
    By city in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2012, 06:41 AM
  3. Replies: 0
    Last Post: 03-19-2012, 07:32 PM
  4. Replies: 1
    Last Post: 03-04-2012, 12:03 AM
  5. [SOLVED] Excel 2002 formula displayed not value formula option not checked
    By Dean in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2006, 10:35 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1