Re: $$Excel-Macros$$ Valiation Query - urgent

2012-01-24 Thread Dhartikumar Sahu
no 1 was there in group to solve my query On Tue, Jan 24, 2012 at 2:06 PM, Dhartikumar Sahu wrote: > > any solution of my query.. > > > On Tue, Jan 24, 2012 at 12:47 PM, Dhartikumar Sahu > wrote: > >> thanks priyanka >> >> but i need another way >> >> when i type manual

Re: $$Excel-Macros$$ Valiation Query - urgent

2012-01-24 Thread Dhartikumar Sahu
any solution of my query.. On Tue, Jan 24, 2012 at 12:47 PM, Dhartikumar Sahu wrote: > thanks priyanka > > but i need another way > > when i type manually on particular cell , auto pickup related that value. > (e.g. if i type *choc *and click on drop down arrow it will display the >

Re: $$Excel-Macros$$ Valiation Query - urgent

2012-01-23 Thread Dhartikumar Sahu
thanks priyanka but i need another way when i type manually on particular cell , auto pickup related that value. (e.g. if i type *choc *and click on drop down arrow it will display the related name of* choc.* On Tue, Jan 24, 2012 at 12:40 PM, PrIyAnKa wrote: > Dear Dhartikumar > > Kindly see i

Re: $$Excel-Macros$$ Valiation Query - urgent

2012-01-23 Thread PrIyAnKa
Dear Dhartikumar Kindly see if below example solves your quarry *xample: Creating a drop down list with data on a different worksheet* For help with this example, see the image above. 1. Enter the following data into the correct cells on*Sheet 1* or a worksheet: *E1* - The Cookie Sho

$$Excel-Macros$$ Valiation Query - urgent

2012-01-23 Thread Dhartikumar Sahu
Hi Experts I have a data of 1000 names in Sheet2, required dropdown validation in sheet1, cell A1 query: if i type some name on cell A1 then it display only the related on that name. it's an urgent -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capit