how do I repeat a drop down box

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

Hi

how did you create the drop down box, and what is the current criteria?
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Need help" <Need [email protected]> wrote in message
news:[email protected]...
>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
>

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

Need help wrote:
> 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
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html