Hello friends,
This help is requested from the experts who also use google docs...
Basically I am trying to put together an excel file on google docs for monitoring a budget so that each account / department can keep entering their data wherever they are and the control authority (myself in this case) can monitor on real-time basis....
A budget excel file on google docs which contains numerous sheets. A separate sheet for each expense head (in some cases, the number of expense heads may be as many as 75 accounts, hence 75 sheets!!!).
I am attaching a sample file which needs to be hosted on google docs after incorporating the other help mentioned below and in the file.
I am trying to create a file to monitor & control costs on a day to day basis.
Each expense head is being taken care of by a specific person. A particular person may be handling more than one account and in some cases, more than one person may be handling a particular expense head. Hence, I need to create a file which has spreadsheets for each account / expense head.
There needs to be a summary sheet which extracts the total expense amount of each expense head and compares it to the allocated budget (incorporated in the attached file).
However, I want only specific people to have access to a particular account. They should not be able to access or see the overall budget and nor should they be able to see the expenses of other accounts, infact they should not even be aware what are the other expense heads, they should see and have access to only their expense head. I have explained all this in the attached file...
Possible???
Looking forward to help from the family of experts...
Bookmarks