View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] dlotz@uafc.com is offline
external usenet poster
 
Posts: 83
Default data validation list form sheet

I have the list on sheet to.
When use data validation it will not let me
selct sheet 2.
I have tried to input
='SHEET',a1:a20

does not work
Plesae advise