Hi Howard,

Am Mon, 16 Dec 2013 01:30:10 -0800 (PST) schrieb :

Works in a normal cell, but in the source window of the drop down, I get an error List source must be a delimited list or a reference to a single row or column.

you can't refer with INDIRECT to 2 different ranges.
=INDIRECT(P8) creates the list for R8
For N8 you have to do it in the cell or with VBA.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2