View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Olivia Olivia is offline
external usenet poster
 
Posts: 11
Default Create a drop-down list from a range of cell

I was wondering if someone can explain to me the steps to take for creating a
drop-down list from a range of cells using a different worksheet in a
different workbook.

I tried following MS Office Help, but I keep getting the same error message
"You may not use references to other worksheets or workbooks for Data
Validation criteria"