$$Excel-Macros$$ Data Validation for Dynamic Range.

Hi Friends, I feel worth sharing this to you. Data validation for dynamic range : *https://youtu.be/sSAMz3kPcMA * Data validation for Stativ range: *https://youtu.be/A8wq_FjaMZE * Thanks & Regards, Prabhu R -- Are you =EXP(E:RT)

$$Excel-Macros$$ Data validation Query

Hey Champs Please see my data validation query. and please let me know when you solved it. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use co

$$Excel-Macros$$ Data Validation and 2 Dimensional / Table lookup

Hi Everyone, I have a table of data: Product Type1Type2Type3Type4Type5Type6 Apple TRUETRUETRUETRUETRUETRUE Peach TRUETRUETRUETRUE OrangeTRUE TRUETRUE What I am trying to do is to allow

$$Excel-Macros$$ Data Validation List clear contents

I am working on an order type form and have 4 different data validation sets. I want to clear the contents of the dependent list when I select the primary list. example set. a18 is dependent on what is selected on a17, a20 is dependent on what is selected on a19 i basically have 4 sets prim

Re: $$Excel-Macros$$ Data Validation

Can you give me a couple sample files describing what you want?  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - Joh

$$Excel-Macros$$ Data Validation

I need to setup validation for a named range based on the value in say cell G5. The rule being as follows: IF cell G5 = 25,000.00 the validation rule is, the named range values <=25,000.00. On the other hand if cell G5 = 25,001.00 the validation rule for the named range is >= 25,000.00. Violati

$$Excel-Macros$$ Data Validation and Unique Array Values

Hi Everyone, I have a question relating to data validation formulas: I have two columns that I am using for defining details for products. The first column is called Category. The data validation for this is done from a simple named range called "Category" and is working properly. The second c

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

Hi chek this.. http://www.contextures.com/xlDataVal02.html Cheers!! On Wed, Jun 18, 2014 at 12:17 PM, Rakesh kumar wrote: > > Dear Friends, > > i want to use data validation in excel. > > first validation - Value would not be repeat in list. > and > In second Validation , show only those va

$$Excel-Macros$$ Data validation help

Dear Friends, i want to use data validation in excel. first validation - Value would not be repeat in list. and In second Validation , show only those value which is belongs to first value. please find the Sample sheets. -- Thanks £ Regards Rakesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP

Re: $$Excel-Macros$$ Data validation - Need help to prevent Duplicate Entry

On Wed, Oct 16, 2013 at 8:29 PM, Secret Shot wrote: > Dear Exterts, > > I am stuck in my project and need your expert advice that ho can i prevent > duplicate data entry in any colom, but i have to use list validation too at > the same time > > So for example my source range is G1:G10 on the basi

RE: $$Excel-Macros$$ Data validation - Need help to prevent Duplicate Entry

Pls use this if you like this. (sorry missed attachment in last mail) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Wednesday, October 16, 2013 8:38 PM To: excel-macros Subject: Re: $$Excel-Macros$$ Data validation - Need help to

RE: $$Excel-Macros$$ Data validation - Need help to prevent Duplicate Entry

Pfa, if u like to use this... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Wednesday, October 16, 2013 8:38 PM To: excel-macros Subject: Re: $$Excel-Macros$$ Data validation - Need help to prevent Duplicate Entry try this

Re: $$Excel-Macros$$ Data validation - Need help to prevent Duplicate Entry

try this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then If Application.WorksheetFunction.CountIf(Range("a:a"), Target.Value) > 1 Then Target.Value = "" MsgBox "Duplicate entry is not allowed", vbInformation, "Note:" End If

$$Excel-Macros$$ Data validation - Need help to prevent Duplicate Entry

Dear Exterts, I am stuck in my project and need your expert advice that ho can i prevent duplicate data entry in any colom, but i have to use list validation too at the same time So for example my source range is G1:G10 on the basis of this i need to put list validation on range A1:A10, but i wan

$$Excel-Macros$$ data validation

HI Team, Need your help in data validation.query is mentioned in attached file. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accu

Re: $$Excel-Macros$$ Data Validation and Automation

ul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Eugene Bernard To: excel-macros@g

Re: $$Excel-Macros$$ Data Validation and Automation

Anybody tried this !!! Regards Eugene On Sat, May 18, 2013 at 8:38 PM, Eugene Bernard wrote: > Dear all, > > Please go through the sheet attached, where there are 4 columns. > > Column 1 is ID which is used to differentiate the component or item. > > Column 2 is Stage, which is used to designat

$$Excel-Macros$$ Data Validation and Automation

Dear all, Please go through the sheet attached, where there are 4 columns. Column 1 is ID which is used to differentiate the component or item. Column 2 is Stage, which is used to designate where the component / item is being processed (ie) stage 1 or 2. Column 3 is completion quantity of compo

Re: $$Excel-Macros$$ Data Validation to force users to enter a particular date format

Select the column, from the menu on the Format> Cell, appear Format Cells window select the Number tab, for Category select Custom, in the Type in dd- mmm-yy and press the OK button. 2013/3/12 Hilary Lomotey > Hello Gurus, > > kindly help on the subject above. i need the users to enter dates in

$$Excel-Macros$$ Data Validation to force users to enter a particular date format

Hello Gurus, kindly help on the subject above. i need the users to enter dates in the format dd-mmm-yy, i tired text(a1,"dd-mmm-yy") in DV ,all custom but its not working. thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Fac

Re: $$Excel-Macros$$ Data Validation

one more point i want to add in Rajan's Explaination is that data validation Keep your data consistent so that it can hold its actual meaning. Lets suppose age of person Can not be a text value it should always be in Numeric value so that we can perform any calculation on it. Regards Prince On

Re: $$Excel-Macros$$ Data Validation issue

This thread makes me think you are typing in the names of your named ranges. It is bettter to press F3 and double click the name to add it. Makes sure there are no typos in the name. Regards David Grugeon On 28 February 2013 18:03, Bé Trần Văn wrote: > Go to Insert> Name> Define, Define Nam

Re: $$Excel-Macros$$ Data Validation issue

Thanks Viper sir On Thu, Feb 28, 2013 at 1:01 PM, The Viper wrote: > "Maruti Kadam" is available in a9. but the original named range is > "Maruti_Kadam". an underscore is missing. > > > On Thu, Feb 28, 2013 at 12:54 PM, amar takale wrote: > >> Dear All, >> I have Data validation sheet in which I

Re: $$Excel-Macros$$ Data Validation issue

"Maruti Kadam" is available in a9. but the original named range is "Maruti_Kadam". an underscore is missing. On Thu, Feb 28, 2013 at 12:54 PM, amar takale wrote: > Dear All, > I have Data validation sheet in which In output sheet cell B6,I put data > validation with Indirect formula that time I

$$Excel-Macros$$ Data validation to stop copy from above or any where!!

Dear Excel guru, I have tried this data validation to stop duplicate entry as well as : =and(countif($e$3:$e$500,e3)=1,len(e3)=15) Though when some is making manual entry its working fine but it stops working if someone copy from above or somewhere else. Can I do something to stop this!! Pleas

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

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

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

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

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

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

Re: $$Excel-Macros$$ Data validation

To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Data validation Dear excel guru, Is there any way I can keep source data list in another sheet (other than where I want to put the data validation) for data validation "list" command. Sandeep Chhajer. Sent on my BlackBerryŽ from Voda

Re: $$Excel-Macros$$ Data validation

*Create a Reference to the Source List* 1. Open the workbook that contains the source list -- DataValWb.xls in this example. 2. Open the workbook in which you wish to use the list in Data Validation. 3. Choose Insert>Name>Define 4. Type a name for the List, e.g. *MyList* 5. In

Re: $$Excel-Macros$$ Data validation

Hi Sandeep, Definitely, you can use Namerange in data validation list command for your requirement. Please ignore the previous sheet & check the new attached sheet for the same, hope it will help you. Regards, Gyana Ranjan Das On Mon, May 28, 2012 at 9:11 PM, wrote: > Dear excel guru, > > I

Re: $$Excel-Macros$$ Data validation

Hi Sandeep, Definitely you can use Namerange in data validation list command for your requirement. Please check the attached sheet for the same, hope it will help you. Regards, Gyana Ranjan Das On Mon, May 28, 2012 at 9:11 PM, wrote: > Dear excel guru, > > Is there any way I can keep source

Re: $$Excel-Macros$$ Data validation

macros@googlegroups.com Subject: $$Excel-Macros$$ Data validation Dear excel guru, Is there any way I can keep source data list in another sheet (other than where I want to put the data validation) for data validation "list" command. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone --

$$Excel-Macros$$ Data validation

Dear excel guru, Is there any way I can keep source data list in another sheet (other than where I want to put the data validation) for data validation "list" command. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 1) Use conci

Re: $$Excel-Macros$$ Data validation not working properly

Ensure that you are using the correct formula and remove unnecessary blanks from the sheet. Also, check the Ignore blanks in data vlaidation box. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

Re: $$Excel-Macros$$ Data validation not working properly

From: B Sharma > Sent: Friday, December 02, 2011 10:52 PM > To: MS EXCEL AND VBA MACROS > Cc: rajanverma1...@gmail.com > Subject: $$Excel-Macros$$ Data validation not working properly > > > Dear Excel Experts. > > I have created a drop down list using data validation

Re: $$Excel-Macros$$ Data validation not working properly

Try removing blank cells in your defined name list or ' ' ' Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: B Sharma Sent: Friday, December 02, 2011 10:52 PM To: MS EXCEL AND VBA MACROS Cc: rajanverma1...@gmail.com Subject: $$Exce

$$Excel-Macros$$ Data validation not working properly

Dear Excel Experts. I have created a drop down list using data validation and the source of the list is a dynamic range created at another sheet. I have checked "Show error alert after invalid data entered" Its working fine and showing the source list in the drop down list but it also accepts an

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

Hi haseeb&XLS, Thank u... *Best Regards,* *Venkat* *Chennai* On Tue, Jul 26, 2011 at 1:26 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hello Venkat, > > Use a separate sheet to get the unique offices. You can hide this sheet, if > you don't want to show. Also use dynamic range

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

please find the link http://www.get-digital-help.com/2010/07/17/create-dependent-drop-down-lists-containing-unique-distinct-values-in-excel/ On Sun, Jul 24, 2011 at 3:49 PM, Venkatesan c wrote: > Dear All, > > I have attached sheet contains my query on Data Validation - Create a drop > down lis

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

Hello Venkat, Use a separate sheet to get the unique offices. You can hide this sheet, if you don't want to show. Also use dynamic range name, so it will update automatically when add/delete entries. Assume there are no blank cells in Data Col_A Offices. If there is blank change the formula in

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

Hi Kaushik, Yes We can remove duplicates I want in Formula that's the reason... already got it.. Thanks for your suggestion * * *Best Regards,* *Venkat* * * On Mon, Jul 25, 2011 at 6:09 AM, KAUSHIK SAVLA wrote: > u can use removw duplicate option in excel. Data then available can bw > used as da

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

u can use removw duplicate option in excel. Data then available can bw used as data validation range. On 7/24/11, Venkatesan c wrote: > Dear All, > > I have attached sheet contains my query on Data Validation - Create a drop > down list containing only unique > > > -- > *Best Regards,* > *Venkat*

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

Hi Dilip, ThanksWorking... *Best Regards,* *Venkat* * * * * On Sun, Jul 24, 2011 at 11:47 PM, Dilip Pandey wrote: > Hi Venkat, > > I have managed to solve your query using defined Names in Excel. > > Let me know if this works. > > Regards, > DILIPandey > > On 7/24/11, Venkatesan c wrote:

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

Hi Venkat, I have managed to solve your query using defined Names in Excel. Let me know if this works. Regards, DILIPandey On 7/24/11, Venkatesan c wrote: > Dear All, > > I have attached sheet contains my query on Data Validation - Create a drop > down list containing only unique > > > -- > *B

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* Venkatesan c > *Envoyé :* dimanche 24 juillet 2011 12:19 > *À :* Google > *Objet :* $$Excel-Macros$$ Data Validation - Create a drop down list > containing only unique > > ** ** > > Dear

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

half Of *Venkatesan c > *Sent:* Sunday, July 24, 2011 3:49 PM > *To:* Google > *Subject:* $$Excel-Macros$$ Data Validation - Create a drop down list > containing only unique > > ** ** > > Dear All, > > ** ** > > I have attached sheet contains my query on D

$$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

Dear All, I have attached sheet contains my query on Data Validation - Create a drop down list containing only unique -- *Best Regards,* *Venkat* * * * * -- -- Some important links for excel users: 1. Follow us on

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

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

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

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

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

Re: $$Excel-Macros$$ Data Validation using Macro

Dear Mahapatra, It can simply be done by using data validation. Use following formula under custom option of Data Validation:- =AND(LEN(A1)<=8,LEFT(A1,3)="SCN") Sample file is also attached with this email. Best Regards, DILIPandey On Fri, Dec 3, 2010 at 4:57 PM, Raj Mahapatra wrote: > HI G

$$Excel-Macros$$ Data Validation using Macro

HI Group, I want to restrict some fields in user form as we have data validation in excel. can you please suggest me the macros using data validation following are my requirements 1. I want to restrict to 8 digits in a text box, in which first 3 characters has to be "SCN" 2. I want to use combo

Re: $$Excel-Macros$$ DATA VALIDATION AND HYPERLINK

Dear Arif, No file is attached, Regards, Vijaykumar On Thu, Oct 7, 2010 at 5:34 PM, arif massani wrote: > THERE IS NO FILE ATTACHED > > On Thu, Oct 7, 2010 at 5:08 PM, santanu_ca wrote: > >> HI >> I HYPERLINKES A SHEET WITH ANOTHER SHEET IN SAME WORK BOOK BUT IT >> DOES'NT WORKS. FILE ATTACHE

Re: $$Excel-Macros$$ DATA VALIDATION AND HYPERLINK

THERE IS NO FILE ATTACHED On Thu, Oct 7, 2010 at 5:08 PM, santanu_ca wrote: > HI > I HYPERLINKES A SHEET WITH ANOTHER SHEET IN SAME WORK BOOK BUT IT > DOES'NT WORKS. FILE ATTACHED. > SANTANU > > -- > > -- > Some impo

$$Excel-Macros$$ DATA VALIDATION AND HYPERLINK

HI I HYPERLINKES A SHEET WITH ANOTHER SHEET IN SAME WORK BOOK BUT IT DOES'NT WORKS. FILE ATTACHED. SANTANU -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitte

$$Excel-Macros$$ Data Validation

Please find the attached sheet for said problem. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at htt

$$Excel-Macros$$ Data Validation & If formula

I have a worksheet where users log daily activities. There are three columns where they need to respond either "Yes" or "No" to these activities based on a specific question. For ease of entry I have made a data validation from a list with either Yes or No as the options for each cell in the col

$$Excel-Macros$$ Data Validation to only allow 7 digit numbers in a entire column

I've been trying to get some cell validation on all cells within column A without any luck. What I want is column A to only accept 7 digit numbers but can't seem to get it working right. All values would have to be 7 in length. All of those 7 digits in a single cell must be all numbers. A cell

$$Excel-Macros$$ Data Validation Help

Hello Experts, I have been a silent member of this group and learnt so many things...But now I am facing a new problemI hope anyone of you can help me out..Problem is as below... I have 2 lists in Column "A" and "B" (as u can see below) and I have validated them in Column C and D. Now what I

$$Excel-Macros$$ Data Validation Problem with Copy/Paste

Hi all! I have a problem with Data Validation, when i copy and paste where Data validation is, than the data validation doesnt check anymore! So how can i check the entries after i copy paste?? thanks --~--~-~--~~~---~--~~