Thread: Validation from list in different worksheet/workbook
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
DM Unseen DM Unseen is offline
external usenet poster
  
Posts: 233
Default Validation from list in different worksheet/workbook
simple use =INDIRECT("Mysheet!MyList") or =INDIRECT(Mysheet!A1:A9") as
formula when selecting list validations. Excel will not be able to spot
you cheating<evil grin


DM Unseen

Reply With QuoteReply With Quote