Validation for multiple sheets?

[John]

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

 

[Franz Verga]

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...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[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

 

[Debra Dalgleish]

Copy the columns with validation on the first sheet
On the next sheet, select the columns where you want to apply the validation
Choose Edit>Paste Special, select Validation, and click OK

 

[Debra Dalgleish]

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

 

[John]

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