You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

data validation across worksheets?

data validation across worksheets?

Price: FREE

King Martin has helped me with validating using an index column which is the basis for a drop down validated list.
Is there any way of having a validated list based on a column in a different worksheet, when I tried to reference it there was an error saying it was not possible but thought you experts may know a way round?

Visit publisher's web-site: data validation across worksheets?

Category and Tags: ExcelTutorials :

Related Tutorials

Data Validation Restriction Referencing other Workbook

Free: Yes
Tags: Excel ›

Following procedure to link Data Validation list to another workbook - dialog box message appears "You may not use references to other worksheets or workbooks for data validation criteria". I am using Excel 2003. Any

Validation Lists And Worksheets

Free: Yes
Tags: Excel › VBA

MissVan,
I would like to post a question to the forum but do not know how to?
I am trying to control a Worksheet name as I have a front sheet which I would like the user to select from a validation list and have some code transport them to a worksheet. Hence the need to control the name of each worksheet so that they can only be one of the list in the validation list?

Data validation / Drop down box

Free: Yes
Tags: Excel ›

I'm trying to create a drop-down box containing a list which is stored in a different workbook. I've tried following the instructions in the help files which seem to suggest this is possible but I get the error message "You may not use references to other worksheets or workbooks for Data Validation criteria"
Am I trying to do the impossible?!
I've been able to do it using a forms control but I haven't used these much before so I'd prefer to use data validation if I can.

Is there a way to reference 2 separate worksheets with validation

Free: Yes
Tags: Excel › Functions

I've been playing around the list command in validation and I was wondering if there was a way to use ranges from 2 different worksheets to be the source to select from. I've tried using the name box command to name the cells and create a union, and that wont work, and something like the 3-D command wont work because I've already programmed a few macro's that are referencing those

if condition with data validation list

Free: Yes
Tags: Excel › Functions

I would like a list for data validation, but the list could be from different tabs.
with validation criteria, allow custom:
=INDIRECT("'"&VLOOKUP(H5,Suppliers!A:B,2,FALSE)&"' !$a:$A")
all data will be in column A, but different tabs. when I use the above formula, I get an error message indicating that I cannot use references to other worksheets or workbooks for Data Validation criteria. But if I use the formula "=items" it references the list from a different worksheet.
any suggestions to get past this?

Related Applications & Scripts

Data Validation class

Free: No
Tags: PHP › Excel Validation

The key to a stable and secure application or website is data validation. Validating things like email addresses, numbers, and other data can be very time consuming and add a lot of extra lines of code to your website if you want to do it the right way. This class can make the data validation part of website development a lot easier.
This class is very easy to use. Because all the methods are static they are faster and callable without instantiating the class. This will say that you only need to include the PHP file in your code and do the validations like below. The method returns a boolean (true when its valid, false when invalid).

EasyValidation - PHP Special validation class

Free: No

EasyValidation is a special PHP class to validate data, It helps you validate forms, Or variables in seconds. It uses two types of validation, The regex validations and, The PHP Validations (PHP Scripts that validates the data).
EasyValidation is easy to use & simple to modify. The thing so special about EasyValidation is that you can add your own validations in second, Whether it’s a regex validation or a PHP one.
Each validation also has its own “Validation error text”, The validation error text is the error that will be provided if the data was not valid.

PHP Form Validation Pack

Free: No

The VDaemon Extension allows quick, easy and effective insertion of form user input validation code into php pages within Adobe Dreamweaver. No PHP coding knowledge is required to create typical form validation! At the same time the VDaemon Extension also assists skilled PHP developers in creating advanced validation solutions.

Flash Mail Form with Validation

Free: Yes
Tags: Flash › Excel Form Validation Forms

This is an action script 3.0 email form with validation functions. I hope this is useful for someone. (Please login to download)

Checkbox Form Validation Control

Free: Yes
Tags: JavaScript › Excel Forms

A very simple and powerfull Checkbox Form Validation javascript !!!! Frequently used script in forms for various situation. (when you need a manual "agree" from the user before submiting a form etc...)

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing