create a defined name/named range refering to your other sheet and use that
in the source

Insert = Name = define

Name: List1
Refers to: =Sheet3!$A$1:$A$10

click the ADD button.

then in the data validation in the list source textbox

=List1

the equal sign is important.

--
Regards,
Tom Ogilvy

"RigasMinho" wrote:

We all know you can create a drop down list in excel where you put in
the values for the source using certain selected cells or you can type
it in yourself.

How do you select different cells on a different sheet?

It just wont let me go to another worksheet when i try changing
worksheets.

Any ideas?