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!

This sounds like an EXCELlent reason to use Access. These types of reports
and permissions are inherent with Access, but would require some fairly
extensive VBA in Excel. If you decide you'll pursue it in Excel, I would
break the tasks down into much smaller questions and ask them in the Excel
VBA newsgroup. Good luck with your project!
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"Mark D. Brown, MSW" wrote in
message ...
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!

Yeah, an actual database program WOULD make it easier to maintain a database.
Unfortunately, here in Nonprofitland, we can't afford such things. So, we
make do with what we have, which is Excel. I guess this is the perfect excuse
to kill a day or two learning Visual Basic...?

"Anne Troy" wrote:

This sounds like an EXCELlent reason to use Access. These types of reports
and permissions are inherent with Access, but would require some fairly
extensive VBA in Excel. If you decide you'll pursue it in Excel, I would
break the tasks down into much smaller questions and ask them in the Excel
VBA newsgroup. Good luck with your project!
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"Mark D. Brown, MSW" wrote in
message ...
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!