three data validation tables related to each other

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

Here's a fresh link:

Depend drop downs with macro.xls 21kb

http://cjoint.com/?iiazUdtUjw

This file contains an event macro so you need to enable macros for it to
work properly.

Sheet1 contains the drop downs, Sheet2 contains the source for the drop
downs.

--
Biff
Microsoft Excel MVP


"Lisa" wrote in message
...
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