Re: $$Excel-Macros$$ Data Validation - No Repitation of data & avoid blank

2011-01-18 Thread Manoj kumar
nder disclaims liabilities for any damages the recipient suffers > as a consequence of receiving any virus through this mail. > > > > *From:* Manoj kumar [mailto:manoj.vishwakarma...@gmail.com] > *Sent:* Tuesday, January 18, 2011 5:31 PM > *To:* excel-macros@googlegroups.com;

Re: $$Excel-Macros$$ Data Validation - No Repitation of data & avoid blank

2011-01-18 Thread Manoj kumar
see if this helps you... Regards, Manoj Kumar On Tue, Jan 18, 2011 at 1:03 AM, wrote: > Dear Masters, > > I have one issue.. > > I am creating one file & wants to use data validation with list (giving > name to a range of vendor). My data sheet contains few columns. Column A - > Vendor name, B

RE: $$Excel-Macros$$ Data Validation - No Repitation of data & avoid blank

2011-01-18 Thread Amit Desai
ties for any damages the recipient suffers as a consequence of receiving any virus through this mail. From: Manoj kumar [mailto:manoj.vishwakarma...@gmail.com] Sent: Tuesday, January 18, 2011 5:31 PM To: excel-macros@googlegroups.com; amit.de...@bdoindia.co.in Subject: Re: $$Excel-Macros$$ Data Val

$$Excel-Macros$$ Data Validation - No Repitation of data & avoid blank

2011-01-17 Thread amit.desai
Dear Masters,   I have one issue..   I am creating one file & wants to use data validation with list (giving name to a range of vendor). My data sheet contains few columns. Column A - Vendor name, B - service type. As one vendor may provide I have 2 or more options in column B against same vendors