Re: $$Excel-Macros$$ Data validation solution

2012-08-24 Thread amar takale
Ok Karan, Thanks for reply & Help. On Fri, Aug 24, 2012 at 2:23 PM, Karan Singh wrote: > No, middle column is not necessary, I just put it for you. Yeah! Arun's > method is right, he's told as I did. First Select all cells > put formula > > Ctrl+Shift+Enter. > > > Karan Singh > > > > > On Fri, A

Re: $$Excel-Macros$$ Data validation solution

2012-08-24 Thread Karan Singh
No, middle column is not necessary, I just put it for you. Yeah! Arun's method is right, he's told as I did. First Select all cells > put formula > Ctrl+Shift+Enter. Karan Singh On Fri, Aug 24, 2012 at 12:01 PM, amar takale wrote: > Thanks Karan > But middle column is necessary? I think not

Re: $$Excel-Macros$$ Data validation solution

2012-08-23 Thread amar takale
Thanks Karan But middle column is necessary? I think not.Y can see Arun reply it is correct,select all cell & Then Press Ctr+Enter. On Fri, Aug 24, 2012 at 11:28 AM, Karan Singh wrote: > Hi Amar, > > See attached sheet.. > > > Karan Singh > > > > > On Fri, Aug 24, 2012 at 11:12 AM, amar takale w

Re: $$Excel-Macros$$ Data validation solution

2012-08-23 Thread amar takale
Hi Noorin Sir Actually there are two worksheet in sheet.I think y are not see it. On Fri, Aug 24, 2012 at 11:28 AM, NOORAIN ANSARI wrote: > Dear Amar, > > See attached sheet, Hope it will help to you. > > -- > With Regards, > Noorain Ansari > http:// > noorainansari

Re: $$Excel-Macros$$ Data validation solution

2012-08-23 Thread अनिल नारायण गवली
Deat Amar U have to select all the required cells at one time and then foto formula bar and then press Cltr+Enter. Hope it should work . reply me when done. Regards, Gawli Anil On Fri, Aug 24, 2012 at 11:12 AM, amar takale <> wrote: > Hi All > I found Data validation sheet in group,It is ok if c