RE: $$Excel-Macros$$ Dependent drop down lists

2010-03-02 Thread Dave Bonallack
Subject: Re: $$Excel-Macros$$ Dependent drop down lists > From: harsha...@gmail.com > To: excel-macros@googlegroups.com > > Christopher and Dave, > > Thanks for the solution; that's almost what I am looking for. About > the list, my lists are always one-one relationship,

Re: $$Excel-Macros$$ Dependent drop down lists

2010-02-27 Thread Christopher Luka
need? >> Regards - Dave. >> >> > Date: Fri, 26 Feb 2010 15:31:13 -0800 >> > Subject: Re: $$Excel-Macros$$ Dependent drop down lists >> > From: harsha...@gmail.com >> > To: excel-macros@googlegroups.com >> >> > >> > Both the soluti

Re: $$Excel-Macros$$ Dependent drop down lists

2010-02-27 Thread Abhishek Jain
Excellent Dave! Simply superb. On Sat, Feb 27, 2010 at 6:25 PM, Dave Bonallack wrote: > Hi, > Does the attached do what you need? > Regards - Dave. > > > Date: Fri, 26 Feb 2010 15:31:13 -0800 > > Subject: Re: $$Excel-Macros$$ Dependent drop down lists > > Fr

Re: $$Excel-Macros$$ Dependent drop down lists

2010-02-27 Thread Abhishek Jain
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

RE: $$Excel-Macros$$ Dependent drop down lists

2010-02-27 Thread Dave Bonallack
Hi, Does the attached do what you need? Regards - Dave. > Date: Fri, 26 Feb 2010 15:31:13 -0800 > Subject: Re: $$Excel-Macros$$ Dependent drop down lists > From: harsha...@gmail.com > To: excel-macros@googlegroups.com > > Both the solutions are not what I am looking for..

Re: $$Excel-Macros$$ Dependent drop down lists

2010-02-27 Thread Christopher Luka
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 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 Dif

Re: $$Excel-Macros$$ Dependent drop down lists

2010-02-26 Thread ankur
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 wrote: > Both the solutions are not what I am looking for...

Re: $$Excel-Macros$$ Dependent drop down lists

2010-02-26 Thread Hanum
Both the solutions are not what I am looking for...what I am looking for is my exampleI think it is very clear. Unlike these solutions, mine are always one-to-one relationship. On Feb 24, 12:29 am, santosh bahuguna wrote: > Create Multiple Range of you data > > Let suppose >  we Have > > A  C

Re: $$Excel-Macros$$ Dependent drop down lists

2010-02-24 Thread santosh bahuguna
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 o

Re: $$Excel-Macros$$ Dependent drop down lists

2010-02-23 Thread Vinod N
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