Hi,
I have this data in a sheet
*Depot Name* *BP Name - Report*
Ahmedabad H K Sales Agency - Sanand Ahmedabad Parshwa Traders -
Gandhinagar Ahmedabad Soham Agency - Chikhli Ambala Chaman Traders - Ambala
Ambala Shiv Trading Company - Assandh Ambala Happy Traders - Barara Ambala R.
K. General Store - Bhiwani
In other sheet I have a drop down list of "Depot Name". Now I want that,
when I select each Depot Name from drop down list, concern BP name will be
vesible vertically. Like this-
Ahmedabad
H K Sales Agency - Sanand Parshwa Traders - Gandhinagar Soham Agency -
Chikhli
Please help me.
Kalyan
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
