CA Ramsai N (Fresher) 04 September 2013
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
CAclubindia Online Learning offers a wide variety of online classes and video lectures for various professional courses such as CA, CS, CMA, CISA as well as various certification courses on GST, Transfer Pricing, International Taxation, Excel, Tally, FM, Ind AS and more. know more