Excel Workbook Creation for Project Management
Budget: $10 – $30 USD
I'm seeking an expert in Excel to create a workbook tailored for our project management needs. The workbook will consist of 7 sheets, with one primary worksheet consolidating data from the other 6 sheets. Each of the 6 project managers will be responsible for updating their individual sheets.
Key Requirements:
- Each project manager must have the ability to view and edit only their designated worksheet, while being restricted from accessing others.
- Updates made by the project managers should automatically populate the primary worksheet, but only when the workbook is saved.
Data Protection Level:
- The security for each project manager's sheet should be at an intermediate level, meaning it involves worksheet visibility restrictions rather than just basic password protection or advanced data encryption.
Data Types:
- The project managers will be updating a combination of both numeric and text data in their respective sheets.
Skills and Experience:
- Proficiency in Excel, particularly in creating complex workbooks with multiple sheets.
- Experience in implementing worksheet visibility restrictions.
- Understanding of how to set up a workbook so that updates populate a primary sheet after saving.
- Ability to design a user-friendly interface for the project managers.
Key Requirements:
- Each project manager must have the ability to view and edit only their designated worksheet, while being restricted from accessing others.
- Updates made by the project managers should automatically populate the primary worksheet, but only when the workbook is saved.
Data Protection Level:
- The security for each project manager's sheet should be at an intermediate level, meaning it involves worksheet visibility restrictions rather than just basic password protection or advanced data encryption.
Data Types:
- The project managers will be updating a combination of both numeric and text data in their respective sheets.
Skills and Experience:
- Proficiency in Excel, particularly in creating complex workbooks with multiple sheets.
- Experience in implementing worksheet visibility restrictions.
- Understanding of how to set up a workbook so that updates populate a primary sheet after saving.
- Ability to design a user-friendly interface for the project managers.