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

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


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

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

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

On subsequent sheets, select the columns where you want to apply the
validation, and press the F4 key, to repeat the paste special.

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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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