View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default Using a 'Select' (Data Validation) List?

Dan

You can use Lists from other sheets if you name the Lists.


Gord Dibben Excel MVP

On 21 Nov 2005 11:57:26 -0800, wrote:

Thanks for the reply Ron! It does help, but it appears that it will not
work across sheets (ie: all my data will have to be on the same sheet -
which I don't want). Any other suggestions?

Thanks,
~Dan