Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

thank you all very muchh On Fri, Sep 9, 2011 at 10:51 AM, Venkat CV wrote: > Hi Bheema, > > See below image and Try Data Validation and use custom and formula as * > =COUNTIF(C:C,C1)=1* > > [image: image.png] > *Best Regards,* > *Venkat * > *Chennai* > *My Linked in profile

Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

Hi Bheema, See below image and Try Data Validation and use custom and formula as * =COUNTIF(C:C,C1)=1* [image: image.png] *Best Regards,* *Venkat * *Chennai* *My Linked in profile * * * On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar wrote: > I

Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

Dear Bheema, Please see attached Sheet... On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar wrote: > I made a userform. linked it with the datasheet. the filenumber acts > as a bridge between userform and datasheet. I have to make the file > number unique in excel. Because the duplica

RE: $$Excel-Macros$$ Code to control the database not to accept repeated number

ACROS Objet : $$Excel-Macros$$ Code to control the database not to accept repeated number I made a userform. linked it with the datasheet. the filenumber acts as a bridge between userform and datasheet. I have to make the file number unique in excel. Because the duplicate numbers also accepting b

$$Excel-Macros$$ Code to control the database not to accept repeated number

I made a userform. linked it with the datasheet. the filenumber acts as a bridge between userform and datasheet. I have to make the file number unique in excel. Because the duplicate numbers also accepting by the datasheet. If it happened so, my intention will not fulfill. So kindly provide solu