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