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.

See

http://www.contextures.com/xlDataVal02.html

In article ,
Dar wrote:

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.

Does this restriction need to be absolute? There are many proposed ways
in the archives:

http://groups.google.com/advanced_gr...ugroup=*excel*

but all of them can be bypassed by anyone who can find these newsgroups.

For security purposes, the best advice is - if you don't want someone to
see your XL data, don't let them access the file.


In article ,
Dar wrote:

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?

How should the copying work? Copy just cell entries? More than one cell
in a row? Should the data be overwritten on sheet 2, or should it always
be copied, producing duplicates?



In article ,
Dar wrote:

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?