Anthony,

Then I don't think there is much use in creating it as a custom list.

Create it as a range on a worksheet as I suggested earlier, name that range,
then use that named range in you DV cell(s).

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anthony" wrote in message
...
thanks Bob but am looking to use a "pick from drop down list". what i mean
is
instead of entering the value i would select the cell and use the drop
down
button which would appear beside that cell to pick from the list i have
created in custom lists.


"Bob Phillips" wrote:

Just enter the first two value into 2 cells, and drag and copy.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anthony" wrote in message
...
hi,
have set up a custom list toolsoptionscustom listsimport list from
cells.
how do i now insert this list in a column on a spreadsheet?
any help would be great
thanks
Anthony