• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. K

    Data validation

    Hi how to validate two columns to get exact value seraing whole of two columns and provide only when Col1, row 2 value = col2, row 2 value. eg: John=John I mean my current formula is =if(h1=m1,1,0). I want a formula where H:H=M:M, but must return true only if h1=m1, h2= m2, etc. I hope I...
  2. K

    VBA search with variable

    Can someone please help on this...
  3. K

    VBA search with variable

    Hi I have one more question and this will complete my problem... I have a search cell/box, in the sheet 1 and when a person enters the Emp ID, excel should validate the username which I am already capturing when adding the details to database, if the username is matching with the current user...
  4. K

    VBA search with variable

    Hi Myles, Thank you very much its working...
  5. K

    VBA search with variable

    I am sorry its E4 and not E2 and i cahnge my range staring from D4..below is my complete code Sub Search() Application.ScreenUpdating = False 'Search Dim Search As String Dim i As String On Error GoTo ErrorCatch Search = Range("Search").Value Sheets("Database").Select...
  6. K

    VBA search with variable

    Hi Thank you for the solution. But I have one more problem my range in sheet one is "D4,D6,D8,D10,D12,E4,E6,E8,E10,E12" to be precise. So by your code I can use "offset(2,0)" till D 12, but the next selection E2 will be a problem. Could you please help....
  7. K

    VBA search with variable

    Hi, I have a question to your copy to entry code what I am trying to do is, after a person searches the data based on a string, all the details for that string must be seleted one by one from second sheet and pasted in first sheet D4, D6, D8... ... I have tried doing this but do not know how...
Back
Top