+ Reply to Thread
Results 1 to 1 of 1

Creating multiple password protected sheets on google docs for a group of people

  1. #1
    Forum Contributor
    Join Date
    03-15-2012
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2019
    Posts
    329

    Creating multiple password protected sheets on google docs for a group of people

    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...
    Attached Files Attached Files
    Regards,
    Navin Agrawal

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with file with multiple spreadsheets on google docs
    By Navin Agrawal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-20-2014, 04:07 AM
  2. pull certain data from google docs form-produced spreadsheet to other docs
    By MisterCadillac in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-11-2014, 04:49 AM
  3. [SOLVED] Using Group and Ungroup on multiple sheet when password protected
    By RandyD123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2013, 08:12 AM
  4. [SOLVED] Can a macro for multiple worksheets enter a password for protected sheets
    By missmea2005 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2012, 08:12 AM
  5. Access - Creating report requiring password/username for multiple people
    By shadestreet in forum Access Tables & Databases
    Replies: 2
    Last Post: 04-25-2009, 04:56 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1