Both of those links have expired.
I still have the one sample file that uses an event macro to clear the drop
down cells when a change is made. Do you want to see that one? Let me know
and I'll post a fresh link.
Biff
"CloudDoctor" wrote in message
...
Hi Biff,
I'm trying to do exactly (I think) the same as Susan - but the link to
your
sample worksheet won't work... has it moved? I'd really like to see it to
solve my problem!
Thanks
CloudDoctor
"T. Valko" wrote:
It would be easier to show you through a sample file than try to explain
it
in writing!
Sample file:
DV.xls 14.5kb
http://cjoint.com/?cneUGXwjf1
I've also used conditional formatting to "clear" the dependent cells when
a
new unrelated selection is made.
Biff
"Susan" wrote in message
...
I want to be able to relate the tables to the one previous to it.
If 'James' is picked from CLIENTS, I would like only 'James Job 1' and
'James Job 2' to be shown from JOBS.
If 'James Job 2 'is picked, then only 'James Job 2 Function 1' and
'James
Job 2 Function 2' and 'James Job 2 Function 3' to be shown from
FUNCTION.
I have tried the INDIRECT function and made it work with 2 tables, but
can
not seem to make it work with 3 tables.
eg:
CLIENTS
James
Arthur
JOBS
James Job 1
James Job 2
Arthur Job 1
Arthur Job 2
FUNCTION
James Job 1 Function 1
James Job 1 Function 2
James Job 1 Function 3
James Job 2 Function 1
James Job 2 Function 2
James Job 2 Function 3
Arthur Job 1 Function 1
Arthur Job 1 Function 2
Arthur Job 1 Function 3
Arthur Job 2 Function 1
Arthur Job 2 Function 2
Arthur Job 2 Function 3