how do I repeat a drop down box

[Guest]

I need to repeat a drop down box in a specific column but also be choosing
from the same criteria. whenever I try to copy it the criteria changes and
goes down one cell

 

[JulieD]

Hi

how did you create the drop down box, and what is the current criteria?

 

[Debra Dalgleish]

If you name the source range, it won't change when you move down a cell.
There are instructions here:

http://www.contextures.com/xlDataVal01.html

Otherwise, use absolute references: =$A$1:$A$10
instead of relative references: =A1:A10