Re: $$Excel-Macros$$ regd: drop down button

2011-02-28 Thread Mahesh parab
Hi Thamu well done ! On Mon, Feb 28, 2011 at 12:56 PM, §»VIPER«§ wrote: > HI Naresh, > > Have look at this, i did something by using function, > find the attachment. > > -- > *Thanks & Regards > > Thamu > * > > > On Mon, Feb 28, 2011 at 11:52 AM, SAJID MANSOOR < > sajidmansooral...@gmail.com> wr

Re: $$Excel-Macros$$ regd: drop down button

2011-02-28 Thread naresh v
Thanks Thammu, Anil and Dilip. On Mon, Feb 28, 2011 at 11:52 AM, SAJID MANSOOR wrote: > Why are you using this lengthy formula? > =INDIRECT(VLOOKUP($B$15,I$2:I$6,1,0)) > instead of > =INDIRECT($B$15)   (Working Fine as above one) > > On Sun, Feb 27, 2011 at 10:19 PM, Dilip Pandey wrote: >> >>

Re: $$Excel-Macros$$ regd: drop down button

2011-02-28 Thread rakesh kumar
How does that drop down button auto hides. Could you please tell me ? How do I place same in my excel sheet. Regards On Mon, Feb 28, 2011 at 12:56 PM, §»VIPER«§ wrote: > at this, i did something by using function, > find the attachment. > -- Rakesh kumar khowal +91 9540084660 +91 986853

Re: $$Excel-Macros$$ regd: drop down button

2011-02-28 Thread §»VIPER«§
HI Naresh, Have look at this, i did something by using function, find the attachment. -- *Thanks & Regards Thamu * On Mon, Feb 28, 2011 at 11:52 AM, SAJID MANSOOR wrote: > Why are you using this lengthy formula? > =INDIRECT(VLOOKUP($B$15,I$2:I$6,1,0)) > instead of > =INDIRECT($B$15) (Worki

Re: $$Excel-Macros$$ regd: drop down button

2011-02-27 Thread SAJID MANSOOR
Why are you using this lengthy formula? =INDIRECT(VLOOKUP($B$15,I$2:I$6,1,0)) instead of =INDIRECT($B$15) (Working Fine as above one) On Sun, Feb 27, 2011 at 10:19 PM, Dilip Pandey wrote: > Hi Naresh, > > Please check the attached file for required solution. > > I have used Name definition ma

Re: $$Excel-Macros$$ regd: drop down button

2011-02-27 Thread Dilip Pandey
Hi Naresh, Please check the attached file for required solution. I have used Name definition manager, data validation with V-lookup option to achieve the desired result. Thanks & Regards, DILIPandey On 2/25/11, naresh v wrote: > Hi Experts, > > I need some help regarding drop down

$$Excel-Macros$$ regd: drop down button

2011-02-25 Thread naresh v
Hi Experts, I need some help regarding drop downs. Please find the attached sheet for your reference. Please help me in this regard. Thanks and Regards, Naresh V -- -- Some impo