Validation Weirdness

[SamuelT]

Hi all,

I've got a worksheet which has two validation drop-downs - the secon
feeds off the first using:

=INDIRECT(SUBSTITUTE(A1," ","_"))

Now, this was working fine and dandy. Last night however, a colleagu
went and changed one of the entries (don't you love it when they d
that!) on the second list and now, for some reason, this particula
option doesn't work: you can select the first option (which relates t
a department), but the second drop-down (containing specific people i
the department) does not work. It's very odd.

I've done the usual checks - looking for symbols, etc that the Exce
might not like. Checked that each column has had a name created for i
and it's all there.

Any ideas why this one particular option doesn't work?

TIA,

Samuel

 

[Bob Phillips]

It looks as though the second list is working off of range names, and maybe
it was changed without changing the name associated with it.

--

HTH

RP
(remove nothere from the email address if mailing direct)