Also is there a way to make the source of list contain values that are
blank?

I selected cells that are blank and it gives me an error of "Source has
to be a delimited list"


RigasMinho wrote:
I also tried - doing this:
define / name test1 = to certain cells, skip some lines, then more
cells.

So it would basically be:
=Welcome!$I$2:$I$17,Welcome!$I$19:$I$35

notice the gap from 17-18 but same column

When i try to name the source become test1 after trying this it then
says "cells have to be in a single row with no spaces"
RigasMinho wrote:
Nice - thanks man.

Another question - what if i have two rows that i define and name as
say: Test1 and Test2

When i go to the source part I would type in:
=Test1,Test2 but it gives me an error of unions, arrays can not be done
in source.

Any work around way?

Tom Ogilvy wrote:
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?