I never could get that to work. ended up writing a short macro to do it.
John

Debra Dalgleish wrote:

And if all sheets have the same layout, you can group them, then use
paste special to apply validation to all sheets simultaneously.

John wrote:

Franz Verga wrote:

John wrote:

Is there a way to use validation over multiple sheets? When I select
several sheets in a workbook validation isn't offered under Data. I
was hoping it would work like formatting over multiple sheets.

John




If I well understand what you mean, you could simply copy the
validation from one sheet to another, not simultaneously validate
them...



I have 60 sheets with 22 columns to be validated each. I would like a
faster way. I can't use copy because there is data in some of the
columns in some of the sheets.

I just learned about validation. I should have set this up before
using the sheets.

John