M
Mark D. Brown, MSW
I run a smallish job placement program with a staff of 15 workers.
Each worker has an identically formatted spreadsheet showing all of their
clients and relevant data about them. Most of this information, they update
on a regular basis. Some of the data (for billing reasons), only our billing
clerk should be able to update.
What I need to be able to do is create a main spreadsheet that compiles all
of the information from the subject spreadsheets. Also, if possible, we would
like to have some information that can be edited only on the main spreadsheet
but displayed on the subject spreadsheets.
As an example, let's say we have two spreadsheets, A and B, with two
collumns: "Name" and "Address". I want to create spreadsheet C, showing all
of the names and addresses from A and B. Next, I would like to have a collumn
in C for "Phone Number" that can be edited in C, with the results showing in
A and B.
Is this possible? If not, how can I set this up for similar results?
Thanks, in advance, for any assistance!
Each worker has an identically formatted spreadsheet showing all of their
clients and relevant data about them. Most of this information, they update
on a regular basis. Some of the data (for billing reasons), only our billing
clerk should be able to update.
What I need to be able to do is create a main spreadsheet that compiles all
of the information from the subject spreadsheets. Also, if possible, we would
like to have some information that can be edited only on the main spreadsheet
but displayed on the subject spreadsheets.
As an example, let's say we have two spreadsheets, A and B, with two
collumns: "Name" and "Address". I want to create spreadsheet C, showing all
of the names and addresses from A and B. Next, I would like to have a collumn
in C for "Phone Number" that can be edited in C, with the results showing in
A and B.
Is this possible? If not, how can I set this up for similar results?
Thanks, in advance, for any assistance!