Hi everyone!

I have 3 questions which I desparately need some help on.

1) I have added a drop-down list to one of my cells and it has 4 different
options. For each option in this list that is selected by a user, I want to
display another drop-down list in the next cell that corresponds to what the
user wants to see. So for example, if a user selects 'Countries' from one of
the options in the first list, I want to display another list in the next
cell that list all countries. If a user selects 'Apples' from the first list,
I want to display another list in the next cell that lists all apples.

I know how to create drop-down lists and associate them to a cell, however,
I don't know how to display a list of options based on what a user selects
from the first list.

2) I have data on sheet 1 and sheet 2. However, sheet 2 has the same data as
sheet 1 but more data than sheet 1. How can I automate copying data from
sheet 1 into sheet 2?

3) I have 10 users and 5 of them should have access to the data on sheet 1
and the other 5 users should have access to the data on sheet 2. How can I
restrict access on a sheet level to users? I can put the Excel workbook on a
network folder and restrict access to the folder that way, but how can I
restrict access on a sheet level?


I would appreciate any help you can give me on this.

I believe Debra Dalgleish (hope I spelled her name correctly) has the
instructions for creating the dependent drop down boxes (data validation
lists) on her site

www.contextures.com

HTH

PC


"Dar" wrote in message
...
Hi everyone!

I have 3 questions which I desparately need some help on.

1) I have added a drop-down list to one of my cells and it has 4 different
options. For each option in this list that is selected by a user, I want
to
display another drop-down list in the next cell that corresponds to what
the
user wants to see. So for example, if a user selects 'Countries' from one
of
the options in the first list, I want to display another list in the next
cell that list all countries. If a user selects 'Apples' from the first
list,
I want to display another list in the next cell that lists all apples.

I know how to create drop-down lists and associate them to a cell,
however,
I don't know how to display a list of options based on what a user selects
from the first list.

2) I have data on sheet 1 and sheet 2. However, sheet 2 has the same data
as
sheet 1 but more data than sheet 1. How can I automate copying data from
sheet 1 into sheet 2?

3) I have 10 users and 5 of them should have access to the data on sheet 1
and the other 5 users should have access to the data on sheet 2. How can I
restrict access on a sheet level to users? I can put the Excel workbook on
a
network folder and restrict access to the folder that way, but how can I
restrict access on a sheet level?


I would appreciate any help you can give me on this.