Biff, I am also trying to do what CloudDoctor and Susan were doing. Can you
make the link available again? Thanks so much!

Lisa

"T. Valko" wrote:

Sample file

Depend drop downs with macro.xls 21.5kb

http://cjoint.com/?dxdpoPZMhs

To see the event macro select Sheet1. Right click the sheet tab and select
View code.

Biff

"CloudDoctor" wrote in message
...
Biff - that would be really useful, thanks

CloudDoctor

"T. Valko" wrote:

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