Sick And Neck Is Very Sore

excel file validation data from other excel sheets

Data validation in Excel to serve as a cell receives only one value that can be a formula or a value range and other such data.

I came across a particular query for validation in the sheet1 taking elements of Sheet2. Normally do data validation, this does not let you choose values \u200b\u200bin other worksheets, solving this is very easy to assign a name to a range.

The attached example, you can download here , is validation of data in cell B2 of Sheet1, which pulls the list of information about the range A2: A6 of Sheet2, as I said this is not usually directly, but must assign a name to this range to be able to call on another sheet. After

name the range given in choosing data validation lists instead of selecting a range is written = NombreRango, and this solves the problem and also enables data validation to input messages and / or error. You can download this small manual will guide you.

I hope it was useful.