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