Data validation on different workbook

  • Thread starter Thread starter gilbert
  • Start date Start date
G

gilbert

Gee....a question just struck my mind suddenly on data validation
function.....just wonder we can validate on certain cells within the
worksheet...can we validate something from another sheet or another
workbook? That is to say, we may want to verify that Sheet 2 cell A1 is
filled up before we could fill in Sheet 1 cell A1. The same goes for
workbook....can we do that?

Please share your experience or thoughts on this.
 
Hi

An Example:
Select A1 on sheet Sheet1, and create a named range, p.e.
CellOnSheet2: Source='A1'
NB! Relative reference

On Sheet1, select cell A1, select Data.Validation.Custom
and enter formula
=(CellOnSheet2="x")

You are allowed enter anything into Sheet1!A1 only when Sheet2!A1 contains
string "x".

With other workbooks, you can mirror needed data into some additional sheet
in your workbook, create a named range, and refer to it like above.
 
Back
Top