You need to have the list in every sheet. If all the sheets have the list in
the same range then Copying the validated cell from the first worksheet and
then pasting specialvalidation should work fine.


"NFaye" wrote in message
...
Hello, I am working on a workbook that has a drop down menu in cell C18 on
sheet1. The list that it references is also located on sheet1 in a hidden
column.
Each of the sheets in my workbook are identical and I am wondering if
there
is quick and simple method to duplicate this function on C18 of each
sheet,
as opposed to having to manually validate each separately. As well, am I
able to make each C18 reference the "list" that has been placed in the
hidden
column on sheet1? Or do I have to hide this list on each sheet as well?

I don't want to link the cells to sheet1, as the repsonse on each sheet is
likely to be different.

Any help would be great. Thank you!