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 wrote in message
...
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 he

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