Oh, I thought it was the other way.

Just use absolute references in you range, such as $A$1 not A1.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Wendy" wrote in message
...
I want to be able to reuse the entries over and over. It is a spreadsheet
of
codes and the codes may need to be entered more than once.

Wendy


"Bob Phillips" wrote:

See http://www.contextures.com/xlDataVal03.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Wendy" <Wendy @discussions.microsoft.com wrote in message
...
I have figured out how to get drop downs in my spreadsheet but I can
not
figure out how to be able to re-use the same one in different boxes
over
again. When I put in a selection from a drop down, it takes it away
from
being one of the choices on my list for the next one. I hope someone
can
help! I am very frustrated!