Validation lists
 

Is there a way to copy a validation list to multiple cells without the list
location changing, ie: a1:a12 changing to a2:a13 ect.
Thanks Phil

Validation lists
 

Before copying and pasting, make the validation list location $A$1:$A
$12 (not A1:A12).

Hth,
Merjet

Validation lists
 

Cool thank you

"merjet" wrote in message
oups.com...
Before copying and pasting, make the validation list location $A$1:$A
$12 (not A1:A12).

Hth,
Merjet