Re: $$Excel-Macros$$ validation

Thanks Sandeep... but not exectly want this.. m talkng about validation issue not Vlookup dear. :(​ RAKESH SHARMA NPI –Team Ericsson India Pvt. Ltd. 4th Floor, Gupta Towers, Commercial Block, Rail Head Jammu & Kashmir, INDIA Phone 01912477440/ 01912477473/441 Fax 01912477442 Mobile +91 99061151

Re: $$Excel-Macros$$ validation

Dear Sir, PFA as per requirement On sheet 1. Cell b2 With Regards Sandeep Kumar Sharma *“Always laugh when you can. It is cheap medicine.*” On Thu, Dec 18, 2014 at 2:51 PM, Rakesh wrote: > > On sheet 1. Cell b2 > > On 18-Dec-2014 2:16 PM, "Victor Momoh" wrote: > > > > On what sheet and on wh

Re: $$Excel-Macros$$ validation

On sheet 1. Cell b2 On 18-Dec-2014 2:16 PM, "Victor Momoh" wrote: > > On what sheet and on what cell do you get that error > > On Thu, Dec 18, 2014 at 9:28 AM, Rakesh wrote: >> >> Dear Experts >> >> I received the following data validation error: Source evaluates to an error. Do you wish to conti

Re: $$Excel-Macros$$ validation

On what sheet and on what cell do you get that error On Thu, Dec 18, 2014 at 9:28 AM, Rakesh wrote: > > Dear Experts > > I received the following data validation error: Source evaluates to an > error. Do you wish to continue? > > and when i continue nothing will changed. :( > > KIndly help > > re

RE: $$Excel-Macros$$ Validation on button click

pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Thursday, April 03, 2014 12:28 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Validation on button click Dear Ravinder, Thanks but provided micro is not

Re: $$Excel-Macros$$ Validation on button click

Dear Ravinder, Thanks but provided micro is not working as requirement. On Thu, Apr 3, 2014 at 12:15 PM, Ravinder wrote: > pfa > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rupesh Patil > *Sent:* Thursday, April 03, 2014 10:45 AM > *To:*

RE: $$Excel-Macros$$ Validation on button click

pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Thursday, April 03, 2014 10:45 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Validation on button click Hello Experts, I need your kind, I have attache sheet w

RE: $$Excel-Macros$$ Validation cells

:47 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Validation cells Dear Ravinder, I have learnt lot from you. you have help me before. this time you have give awesome formulas for mobile and email column. just one query DOB Column don't accepts any date format, I

Re: $$Excel-Macros$$ Validation cells

Dear Ravinder, I have learnt lot from you. you have help me before. this time you have give awesome formulas for mobile and email column. just one query DOB Column don't accepts any date format, I have entered 30-09-1986 or 09/30/1986 format but not accepted, am I doing something wrong On Thu

RE: $$Excel-Macros$$ Validation cells

Pfa. try this may be you like...I have put data validation till 20th row you can increased as per your requirement. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Thursday, March 13, 2014 9:49 AM To: excel-macros@googlegroups.com Subje

Re: $$Excel-Macros$$ Validation Micro

Dear Ravinder, I am really thankful your interest on this thread. you were ask me sample file, so Please find in attachment. Thanks Ruepsh, On Tue, Oct 29, 2013 at 11:12 AM, Ravinder wrote: > Pls give some example file so > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > exc

RE: $$Excel-Macros$$ Validation Micro

Pls give some example file so From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Tuesday, October 29, 2013 10:43 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Validation Micro Hi exports I have sheet with some colum

Re: $$Excel-Macros$$ Validation through Macro!!!

Thanks a lot for your help. Sure it will help me a lot, but if I stuck somewhere then definitely I'll get back to you. On Sat, Jul 6, 2013 at 5:54 PM, vba wrote: > Hi Indrajit, > > You have asked something diff.. > > PFA sheet where i have set restrictions for few cases.. I hope you can > mana

Re: $$Excel-Macros$$ Validation through Macro!!!

Hi Indrajit, You have asked something diff.. PFA sheet where i have set restrictions for few cases.. I hope you can manage show for rest cases.. Let me know if you need further help. How it works: Set min & max value in sheet 1 & error message . As soon as you select any cell in sheet 2, ce

Re: $$Excel-Macros$$ validation

Dear Souza, Pl see the attached data is it ok? Warm Regards, Gawli Anil On Fri, Jun 14, 2013 at 12:00 AM, Thiago Souza wrote: > I need to validate an information like this** > > ** ** > > __AB_C > > Name 1 w w > > Name 2 w w > > Name 3 o

Re: $$Excel-Macros$$ Validation

Thank you Noorain and Aindril...one thing Noorain u have been always inspiring  for me From: Aindril De To: excel-macros@googlegroups.com Sent: Monday, 31 October 2011 4:50 PM Subject: Re: $$Excel-Macros$$ Validation Hi Shashank, Considering A2 has

Re: $$Excel-Macros$$ Validation

Dear Shashank, Select both Cell and Type formula in Data-Validation-Custom =AND($A2="India",or($B2=8,$B2=11)) Check Attached Sheet. Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Validation

Hi Shashank, Considering A2 has "country" and The Code in B1, the formula to be placed in C1 is as follows: =IF(AND(A2="India",OR(B2=8,B2=11)),"TRUE","ERROR") On Mon, Oct 31, 2011 at 4:40 PM, shashank bhosle < catchshashankbho...@yahoo.co.in> wrote: > Hello , > > When Cell= India and other cell

RE: $$Excel-Macros$$ Validation rule and 'X'

Hi, Yes, it's possible to have more than one rule. Let me know what it is you actually need, and I'll try to help you acheive it. Regards - Dave. > Date: Fri, 27 Aug 2010 07:53:14 -0700 > Subject: Re: $$Excel-Macros$$ Validation rule and 'X' > From: janes...

Re: $$Excel-Macros$$ Validation rule and 'X'

Hi Dave, The first solution was exactly what I needed. Works great. Now, is is possible to have more than one validation rule per cell, perhaps by creating an array in the Formula box under Validation / Settings? Hane -- --

RE: $$Excel-Macros$$ Validation rule and 'X'

Hi, First of all, you can't use Data Validation after the data is entered. You may apply the validation, but it won't react to invalid data. It only responds to data entered after the validation rule is in place. If you want to be alerted to invalid data that is already present, you'd probably