What I understand from Hanum's query is:
He wants two drop down lists which are actually dependent on EACH OTHER.
Code no. should be changed on the basis of Names and,
Names should be changed on the basis of Code nos.
Now the problem is -
When we change the code no. it should show the city name (okay till this
far) but as soon as we change the city name, the code no. should get changed
according to new city name selected, and when code no. got changed, it
should show a new city name again....and this goes on...
Hanum,
If you want the corresponding results in separate lists, I can do
that....but both in same two lists is I am afraid beyond my knowledge.
Regards,
AJ
On Sat, Feb 27, 2010 at 3:00 PM, Christopher Luka <
christopher.l...@gmail.com> wrote:
> Check out the attached file. I think it will meet your requirements, and
> no VBA required.
>
>
> On Fri, Feb 26, 2010 at 11:25 PM, ankur <ankurpande...@gmail.com> wrote:
>
>> hi hanum
>> plz attach a sample file
>> so it will more easy for us to help u
>>
>> Have A Nice Time & Enjoy Life
>>
>> Regards:
>> CMA Ankur Pandey
>> (Someone Different)
>>
>> I'm not the best but i'm not like the rest~~
>>
>>
>>
>> On Sat, Feb 27, 2010 at 5:01 AM, Hanum <harsha...@gmail.com> wrote:
>> > Both the solutions are not what I am looking for...what I am looking
>> > for is my example....I think it is very clear.
>> > Unlike these solutions, mine are always one-to-one relationship.
>> >
>> > On Feb 24, 12:29 am, santosh bahuguna <santoshbahug...@gmail.com>
>> > wrote:
>> >> Create Multiple Range of you data
>> >>
>> >> Let suppose
>> >> we Have
>> >>
>> >> A C
>> >> A D
>> >> A E
>> >> B F
>> >> B G
>> >> B H
>> >>
>> >> Give the Name A1:A6 MAIN SOURCE
>> >>
>> >> GIVE Name the B1:B3 as A
>> >> GIVE Name the B4:B6 as B
>> >>
>> >> select the Column where you want to show main SOURCE
>> >>
>> >> and in sub menu Give Formula of =Indirect("Range of the data in bases
>> of you
>> >> want to display LIke A or B")
>> >>
>> >> Regards
>> >> Santosh Bahuguna
>> >>
>> >>
>> >>
>> >> On Tue, Feb 23, 2010 at 10:12 PM, Vinod N <nvino...@gmail.com> wrote:
>> >> > Hi Hanum,
>> >>
>> >> > Please find attached the Solution provided by one of the Gurus for a
>> >> > query similar to the one posted by you...
>> >>
>> >> > Use the attached.. in the meantime, Gurus will provide you with exact
>> >> > solution....
>> >> > if possible send us a sample file for exact query...
>> >>
>> >> > Vinod
>> >>
>> >> > On Tue, Feb 23, 2010 at 11:28 PM, Hanum <harsha...@gmail.com> wrote:
>> >> > > I have a unique problem that I need your help. Here it is:
>> >>
>> >> > > There is a list of some numbers and names associated with each of
>> the
>> >> > > numbers. There are two drop down lists for a user to pick from -
>> one
>> >> > > drop down for the numbers and another for the names. When a user
>> >> > > selects a particular number from the number drop down, I want the
>> the
>> >> > > name drop down to show the correspsonding name. That's not all -
>> when
>> >> > > the user selects a particular name from the name drop down, the
>> number
>> >> > > drop down to show the correspsonding number.
>> >>
>> >> > > Here's an example: 01,.....,15 are in drop down A, and
>> >> > > Arizona,....,Virginia are in drop down B. When I select 05 from
>> drop
>> >> > > down A, the drop down B should update to New Mexico. Next, if I go
>> to
>> >> > > drop down B and change the current value 'New Mexico' to say
>> >> > > 'Virginia', drop down A should change to 15.
>> >>
>> >> > > 01 Arizona
>> >> > > 03 California
>> >> > > 05 New Mexico
>> >> > > 10 New York
>> >> > > 15 Virginia
>> >>
>> >> > > Please help.
>> >>
>> >> > > --
>> >>
>> >> >
>> ----------------------------------------------------------------------------------
>> >> > > Some important links for excel users:
>> >> > > 1. Follow us on TWITTER for tips tricks and links :
>> >> >http://twitter.com/exceldailytip
>> >> > > 2. Join our Facebook Group @
>> >> >http://www.facebook.com/group.php?gid=287779555678
>> >> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
>> >> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>> >> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>> >>
>> >> > > To post to this group, send email to excel-macros@googlegroups.com
>> >>
>> >> > > <><><><><><><><><><><><><><><><><><><><><><>
>> >> > > HELP US GROW !!
>> >>
>> >> > > We reach over 6,800 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
>> >>
>> >> > --
>> >> > Thanks and Regards
>> >>
>> >> > Vinod N
>> >>
>> >> > --
>> >>
>> >> >
>> ----------------------------------------------------------------------------------
>> >> > Some important links for excel users:
>> >> > 1. Follow us on TWITTER for tips tricks and links :
>> >> >http://twitter.com/exceldailytip
>> >> > 2. Join our Facebook Group @
>> >> >http://www.facebook.com/group.php?gid=287779555678
>> >> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
>> >> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>> >> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>> >>
>> >> > To post to this group, send email to excel-macros@googlegroups.com
>> >>
>> >> > <><><><><><><><><><><><><><><><><><><><><><>
>> >> > HELP US GROW !!
>> >>
>> >> > We reach over 6,800 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- Hide quoted
>> text -
>> >>
>> >> - Show quoted text -
>> >
>> > --
>> >
>> ----------------------------------------------------------------------------------
>> > Some important links for excel users:
>> > 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> > 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> > 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 6,800 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
>> >
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 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 6,800 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
>>
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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 6,800 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
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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 6,800 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
