Hi!

have few questions regarding data validation.
1) Can the source of the validation criteria be dfrom a different sheet?
2) when choosing a data via the validation criteria can I cause an other cell to change automaticly?
3) when choosing a data via the validation criteria. can I cause an other call to have the ability of a chose only from other set of data ext?

thanks