Data validation problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I tried to develop a program using Excel and now facing some technical problem and expect to get the help from all of you. As what we know excel has data validation function and when I'm trying set the validation criteria with list and get data source from another worksheet. The system always prompts me "you may not use references to other worksheets or workbook for data validation criteria". Anyone has the idea to solve this program

Thanks & Regard
 
If the data validation list is in another worksheet then you have to refer
to it by way of a named range. It must be a workbook-level ie global named
range, not one at worksheet leve.

kysiow said:
Hi!

I tried to develop a program using Excel and now facing some technical
Click to expand...
problem and expect to get the help from all of you. As what we know excel
has data validation function and when I'm trying set the validation criteria
with list and get data source from another worksheet. The system always
prompts me "you may not use references to other worksheets or workbook for
data validation criteria". Anyone has the idea to solve this program.
 
Back
Top