ICICI

Creatuing sub list in drop down list box in excel


CA Ramsai N (Fresher)     04 September 2013

CA Ramsai N
Fresher 
 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

 

 

Regards

Ramsai


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 »