CCI Online Learning
What do you want to learn today?
     
CIBIL

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

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: 198 times
1 Like



Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  


Related Threads


Loading

Popular Discussion


view more »



Trending Tags
itc
ca exams
exams
icai
Professional Resource
esic
unified portal
Service Tax
taxpayers
gstr 9
corporate law
gst return
cag
accounts
cbdt
students
epfo
ca rankholder interview
ca students
tds
income tax
coronavirus
newgstreturn

FM by Grant Thornton    |    x