Hello everyone,
I am working on a manpower lookahead sheet for my company. The goal of this sheet is to allow project managers and project supervisors to input their desired crew size for a project based on a monthly timeline. The sheet will then compare the total crew required crew size for each month (based on a sum of all the projects' required crew sizes) and tell the user if more manpower is required for each month.
We already have a static version of this tool, but we're trying to make it more dynamic. Ideally, we want the project list to be dynamically populated by linking to an external CSV report that will be updated on a daily, weekly, or monthly basis. The problem I am trying to solve is:
How do I allow the users to input static data (crew size for each month) while still having that data follow its corresponding project if the dynamic list changes? Is this something that is possible with Excel alone? Will I need to learn Access to use a combination of a database and an Excel sheet? Is there another way I should be doing this that makes more sense?
I have attached an example of what I am trying to achieve. Basically, I want the numbers on the right to be attached to the same project on the left, so even if the project changes rows, the data from the right will change rows to match the same project. If a project disappears from the report, I would prefer if the data on the right is cleared (for that specific project).
If I can clarify anything further, please let me know.
Bookmarks