Any help or guidance would be amazing on this one:
I'm wanting to use Excel as a project management tool. I have designed individual project sheets, with a cel per day. Each sheet is a 6 month snapshot of the project, and depending on the project there might be just one sheet (6 months) or 4 sheets (2 years).
What I need now is an overview spreadsheet (in a separate file) which shows what is going on with all projects, but not all the details. I want to control (with formulas or conditioning) what is carried over.
I am happy to fill botht the individual sheets and overview sheets with formuals etc, as long as the interface is simple, as I won't be using it on a day to day business, other users will.
Everything I have found on the net so far seems to rely on Gantt charts, and this is what I am after I guess, but with more control, and the feeder sheets going into an overview sheet.
Thanks in advance for anyones help.
I'm wanting to use Excel as a project management tool. I have designed individual project sheets, with a cel per day. Each sheet is a 6 month snapshot of the project, and depending on the project there might be just one sheet (6 months) or 4 sheets (2 years).
What I need now is an overview spreadsheet (in a separate file) which shows what is going on with all projects, but not all the details. I want to control (with formulas or conditioning) what is carried over.
I am happy to fill botht the individual sheets and overview sheets with formuals etc, as long as the interface is simple, as I won't be using it on a day to day business, other users will.
Everything I have found on the net so far seems to rely on Gantt charts, and this is what I am after I guess, but with more control, and the feeder sheets going into an overview sheet.
Thanks in advance for anyones help.
