Main and subject spreadsheets

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!
 
A

Anne Troy

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
 
M

Mark D. Brown, MSW

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...?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top