Quote:
Originally Posted by Phideaux
can this approach draw values from another worksheet within the workbook?
|
Yes, see attached.
You should be able to hide the
Stuff sheet
Because you use Excel 2003 I've had to add an extra named range (
NPS_Size) because Excel 2003 doesn't seem to like data validation referring directly to another sheet.