Creatuing sub list in drop down list box in excel

CA Ramsai N (Fresher)     04 September 2013

CA Ramsai N
 61 likes  594 points

| My Other Post

How to  Create "Sub list" in drop down list which depends on "Main list"



Step:: 1 Take raw data

Step:: 2 Create Name box for each of specified data (here "Country", "India", "USA", "Canada" are Name boxes 

                    (to view Name boxes == Formulas menu > Name > Manager )

Step:: 3 First create "Drop down list" and again "Drop down list"


(See attached excel sheet)


It will be very use ful for those preparing financials using Sumif formula, that will be useful to update the financials with change in Trailbalance with in span of seconds.

For that you have create Note headings as Main list and Items in notes as Sub list


Hope useful for you. Inform me any problem





Attached File : 666306 1227413 sub list.xlsx downloaded: 186 times
1 Like

Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Popular Discussion

view more »