Validation for multiple sheets?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 03 Jul 2006 02:01 GMT

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

Reply to this Message

Franz Verga - 03 Jul 2006 11:01 GMT

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

Signature

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Reply to this Message

John - 03 Jul 2006 13:52 GMT

>>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
[quoted text clipped - 4 lines]
> 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

Reply to this Message

Debra Dalgleish - 03 Jul 2006 14:38 GMT

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

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

>>> 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
[quoted text clipped - 13 lines]
>
> John

Signature

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

Reply to this Message

Debra Dalgleish - 03 Jul 2006 14:40 GMT

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

>>> 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
[quoted text clipped - 13 lines]
>
> John

Signature

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

Reply to this Message

John - 16 Jul 2006 17:03 GMT

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

> And if all sheets have the same layout, you can group them, then use
> paste special to apply validation to all sheets simultaneously.
[quoted text clipped - 17 lines]
>>
>> John

Reply to this Message