D
Dar
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 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.