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

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

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

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

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

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

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

Thanks to all of you. Its working fine. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: "dguillett1" Sender: excel-macros@googlegroups.com Date: Mon, 28 May 2012 10:52:43 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Mac

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

use a define name for the dv list in the other sheet such as dvlist then in the dv> list > =dvlist Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: chhajersand...@gmail.com Sent: Monday, May 28, 2012 10:41 AM To: excel-macros@googlegroup

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

Remove check from Ignore Blanks in data validatoin On Sat, Dec 3, 2011 at 7:20 PM, dguillett1 wrote: > 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

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: $$Excel-Macros$$ Data validation

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

Hi Daniel, Thanks..it's Working *Best Regards,* *Venkat* * * * * On Sun, Jul 24, 2011 at 6:01 PM, Daniel wrote: > Another way to do it (see attached workbook). > > ** ** > > Regards. > > ** ** > > Daniel > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@go

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

Hi Rajan, It's Working Thanks... *Best Regards,* *Venkat* * * * * On Sun, Jul 24, 2011 at 4:19 PM, Rajan_Verma wrote: > *Hi Venkat* > > *See the attached Sheet* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Venkatesan c > *Sent:* Sun

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

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

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