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

Just upload the actual excel file to see if the Frog can be helped. On Thursday, February 23, 2017 at 7:37:36 AM UTC+3, The Frog wrote: > > Hi Everyone, > > I have a table of data: > Product Type1Type2Type3Type4Type5Type6 > Apple TRUETRUETRUETRUETRUE

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

hye bro.. PFA With video on youtube https://www.youtube.com/watch?v=iJSdaoGAG-A and confirm me On Friday, March 31, 2017 at 5:30:44 PM UTC+5:30, sourav devrani wrote: > > Hey Champs Please see my data validation query. > and please let me know when you solved it. > -- Are you =EXP(E:RT)

$$Excel-Macros$$ Re: data validation upon saving...

Thank you for your reply Mandeep. This is a time log to log activities with the 8 hour work day. So based on breaks and other tasks we determined that 7.25 should be the amount of hours that the employees will need to account for. There are times when the Time Logs are missing hours...seems

$$Excel-Macros$$ Re: data validation upon saving...

Hi Lin, Check the attachment and find the same Scenario as required !! One thing which i didn't understand from where predetermined Total comes.(If I am assuming it correctly You are trying to validate values from two different sheets), Set this scenario in your sheet accordingly. Regards, Ma

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

check here.. http://excelautomate.blogspot.in/2013/11/function-to-find-unique-items-in-list.html On Wednesday, 16 October 2013 20:29:51 UTC+5:30, Excel ka Keeda wrote: > > Dear Exterts, > > I am stuck in my project and need your expert advice that ho can i prevent > duplicate data entry in any c

Re: $$Excel-Macros$$ Re: Data Validation to force users to enter aparticular date format *

thanks prince much apprciated. On Thu, Mar 14, 2013 at 5:48 AM, Prince wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (prince141...@gmail.com) Add cleanup > rule

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

Hi Hilary. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$B$3" Then MsgBox "Please Enter date In dd-mmm-yy Format" End If End Sub Just Paste the following Code and modify the same according to your Requirment. Regards Prince On Tuesday, Mar

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

Hi Sandeep, whenever we copy any data from any source we are not sure about the spaces into the value. So i feel there may be the data item that you want not duplicate contain any space and making it another explicit value. So for avoiding above problem use "Trim()" fuction to remove the space

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

Wow.Vabs. This will be grt.Now I know my mistek Thanks a lot very much Best Regards, Amar On Sat, Sep 22, 2012 at 11:15 AM, Vabz wrote: > Hi > > There was error in formula.. > > Pl check.. > > Rgds//Vabs > > > On Saturday, September 22, 2012 10:58:59 AM UTC+5:30, amar takale wrote: >

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

Hi Company name is final drill down filters which you have created & there is no name defined agst yor end result viz. 3M India Ltd. The given method is used to create dependent dorp down list and you are at the last step. There you have to use formula vlookup to get result in cell =VLOOKUP($

$$Excel-Macros$$ Re: Data Validation

Hi This is interesting solution can you plz explain how u did?? Regards Ruchi On Wed, Sep 30, 2009 at 6:15 PM, Umesh Gupta 3 wrote: > please find solved  sheet > > - Original Message - > From: Aligahk06 > To: excel-macros@googlegroups.com ; dilipan...@gmail.com > Sent: 30 September, 200

$$Excel-Macros$$ Re: Data Validation

PM Subject: $$Excel-Macros$$ Re: Data Validation Hi Aligah, The file attached has been solved. As the references for data validation can not be given from another sheet, I have taken them in the current sheet and then used data validation. Thanks. Let me know in case of any queries

$$Excel-Macros$$ Re: Data Validation

Dear Mr. Umesh, Could you please tell me step by step, So that we can know how to do it. It is very usefull for us in our job. Please explain in step, I will be very thankfull to you. Thanks & Regards, Imran Khan Project Control Engineer KBR - Kellog Brown & Root Saudi Kayan Olefins Project Al-J

$$Excel-Macros$$ Re: Data Validation

please find solved sheet - Original Message - From: Aligahk06 To: excel-macros@googlegroups.com ; dilipan...@gmail.com Sent: 30 September, 2009 1:45 PM Subject: $$Excel-Macros$$ Data Validation Please find the attached sheet for said problem. --~--~-~--~-

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

Hi Wes, Attached herewith is the solution with explanation. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Aug 4, 2009 at 6:41 AM, Wes wrote: > > I've been trying to get some cell validation

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

Hi Wes Not too sure what the problem is exactly as I have just used "Data Validation" => "Settings" => "Allow " = "Text length" => "Data" = "less than or equal to" => "Length" = "7" then tested it on a cell with custom format of "000" and it seems to be OK. Let me know how you go if this is

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

Remember that Excel stores numbers as numbers. it may DISPLAY them in all variety of things. For instance, the number 109.123456 Could be SHOWN as: 109.123456 109.12 109.1234560 4/18/1900 2:57:47 AM 4/18/00 2:57 AM the letter "m" Each of these LOOK different, but are actually the same numb

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

Hi Wes, Try formatting your data as text, then use the following data validation: =AND(LEN(A1)=7,ISERROR(VALUE(A1))=FALSE) Regards - Dave. > Date: Mon, 3 Aug 2009 18:11:25 -0700 > Subject: $$Excel-Macros$$ Data Validation to only allow 7 digit numbers in a > entire column > From: wesle

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

Please find attachd as required by you, I have used "IF", let m know if it was useful On Thu, Apr 9, 2009 at 11:51 AM, Harmeet Singh wrote: > Try attached file > > On Wed, Apr 8, 2009 at 9:06 PM, anish@gmail.com > wrote: > >> >> Hello Experts, >> >> I have been a silent member of this group

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

Try attached file On Wed, Apr 8, 2009 at 9:06 PM, anish@gmail.com wrote: > > 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 Col

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

Hi, You can try doing past special values this retain the validations Regards Sathish Jalendran -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of xmux Sent: 18 March 2009 06:14 pm To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macr

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

- Hi xmux, Dave is absolutely right. and here is how you can achieve this. 1. Press Alt+F11. 2. Double Click on the Sheet in Left pane, where you've placed Data Validation. 3. Then Paste the following code in Code wind

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

Hi xmux, This is the main weakness of data validation. The only way around it is to check the entry using a VBA Change event code. Regards - Dave. _ View photos of singles in your area. Click Here http://a.ninemsn.com.au/b.aspx?UR