View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy
 
Posts: n/a
Default Data Valitaion Input message

Hello
I have a list of definitions listed in 'info'!A1:a25. I would like to use
the cell contents of this list as data validation on numerous sheets. The
definitions are in the same row in the list that I would like use them in
Data Validation input message. ie. Data Validation Input Message for
'Company1'!A1 = 'info'!A1

Is there a way I can use a formula in Data Validation Input Message so I
dont have to retype the whole definition each time?
Thanks