validation data for drop down list

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

Guest

Hi - simple question. I am using Excel 2003 and trying to put the data I use ifor a drop down list (using Data | Validation) in another worksheet, but it won't let me do it. I used to be able to do this in older versions of Excel. Do I have some setting wrong?

Charlie
 
You cant use cell references eg Sheet3!A1:A20, but if you name the range to
say Range1,
Data Validation will accept =Range1
Charlie C said:
Hi - simple question. I am using Excel 2003 and trying to put the data I
Click to expand...
use ifor a drop down list (using Data | Validation) in another worksheet,
but it won't let me do it. I used to be able to do this in older versions
of Excel. Do I have some setting wrong?
 
Back
Top