+ Reply to Thread
Results 1 to 8 of 8

data validation

Hybrid View

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    data validation

    Hello to all.
    I have 2 sheets:
    In one I have a database with a set of data that I have named "articles" with define > name
    in the second I enter this validation:

    if the number entered is not in "articles" or incorrectly reports the error.

    The formula as it should be done?
    I hope I was understandable.
    Thank you,
    max_max
    ------------------------------------------------------------------------------------------
    Ciao a tutti.
    Ho 2 fogli:
    In uno ho un data base con una serie di dati che ho nominato "articoli" con definire > nome
    nel secondo devo inserire questa convalida:

    se il numero inserito non è in "articoli" o è errato segnala l'errore.

    La formula come deve essere fatta?
    Spero di essere stato comprensibile.
    Grazie,
    max_max
    Last edited by max_max; 09-08-2013 at 03:12 AM. Reason: traslation wrong

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: data validation

    Select the cell (or range) where you will be entering the data, select Data Validation, select LIST, enter =articles
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: data validation

    Hello FDibbins
    thank you for your reply but as always I mean bad.
    The validation does not work because the column where there is a validation there is a link to another column.
    Place the file to understand.
    max_max
    --------------------------------------------------------------------------------------------------------------------
    Ciao FDibbins
    grazie della risposta ma come sempre mi spiego male.
    La convalida non funziona perche la colonna dove c'è la convalida c'è un collegamento ad un'altra colonna.
    Posto il file per capire.
    max_max

    convalida.xlsx

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: data validation

    You need to apply the DV to column B, not column D

  5. #5
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: data validation

    Unfortunately the file I posted is an example.
    In column B, there is another validation of the original file data.
    The column D in the original file is hidden.
    For this reason the new validation must be in column D.
    max_max
    -------------------------------------------------------------------
    Purtroppo il file che ho postato è un esempio.
    Nella colonna B del file originale c'è un'altra convalida dati.
    La colonna D nel file originale è nascosta.
    Per questo la nuova convalida deve essere nella colonna D.
    max_max

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: data validation

    You get better help if you make an example that is the same as your real workbook.

    Then you can copy the solutions (add the solutions) easy in your real workbook.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: data validation

    DV will not work with formulas in the cell

  8. #8
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: data validation

    The file is this:
    convalida con collegamento.xlsx
    In the same column there are 2 validation data.
    I hope it is possible in any other way, because there are formulas and says FDibbins is not possible.
    max_max
    -----------------------------------------------
    Il file è questo:
    convalida con collegamento.xlsx
    Nella stessa colonna ci sono 2 convalida dati.
    Spero sia possibile in altra maniera, perchè ci sono delle formule e come dice FDibbins non è possibile.
    max_max

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 07-03-2014, 02:37 AM
  2. Adding Date Data Validation to cells with List Data Validation
    By biggtyme in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-03-2013, 09:47 AM
  3. Using Defined Names with Data Validation Depend and Data Validation Multi Select
    By Vinnie Chan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-01-2012, 05:36 PM
  4. validation rules not working when someone copy paste data on validation cell
    By jthakrar in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-17-2010, 03:36 AM
  5. data validation-How to set data validation for user to key in 24H time format?
    By crapit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2006, 08:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1