I have 52 different worksheets i need to create data validation for, i can
not select all worksheets and create data validation? Is there any easy way
to do this without creating for all 52 worksheets?

Thank you!
Susan

Do your validation for one sheet. Copy the cells in that sheet. Select the
remaining sheets and Paste Special - Validation
--
HTH...

Jim Thomlinson


"SUSAN" wrote:

I have 52 different worksheets i need to create data validation for, i can
not select all worksheets and create data validation? Is there any easy way
to do this without creating for all 52 worksheets?

Thank you!
Susan

Hi,

Lets say you want to put data validation in cells A1:A100 for 52 shetts
(same cells in each sheet) if this is what you want to do then try this:

put the data validation in the cells A1:A100 in the first sheet and then
select A1:A100 and click on copy. then go to second sheet and make cell A1
activate then hold Ctrl and then click on sheet tabs 3-52 and then click on
past.

Thanks,
--
Farhad Hodjat


"SUSAN" wrote:

I have 52 different worksheets i need to create data validation for, i can
not select all worksheets and create data validation? Is there any easy way
to do this without creating for all 52 worksheets?

Thank you!
Susan

If the Data-Val list would be the same for all sheets, I think you could
also create the list, highlight it, then Insert-Name-Define (name it), then
in the cells you need to use it on you 52 other sheets, Data-Val-List in the
list name box, enter =xxxxx

HTH

"Farhad" wrote in message
...
Hi,

Lets say you want to put data validation in cells A1:A100 for 52 shetts
(same cells in each sheet) if this is what you want to do then try this:

put the data validation in the cells A1:A100 in the first sheet and then
select A1:A100 and click on copy. then go to second sheet and make cell
A1
activate then hold Ctrl and then click on sheet tabs 3-52 and then click
on
past.

Thanks,
--
Farhad Hodjat


"SUSAN" wrote:

I have 52 different worksheets i need to create data validation for, i
can
not select all worksheets and create data validation? Is there any easy
way
to do this without creating for all 52 worksheets?

Thank you!
Susan