We require information from a number of Microsoft Project files to be merged into an Excel spreadsheet and displayed as per the example attached by use of a macro in Excel. It is important that the user just presses the macro button and all the information in the sheet is built automatically.
The number of projects will vary, but they will always be held in 1 MS Project file (see attached example).
In Excel coloured blocks are used to represent the different Project resources and the dates those resources are in use. No resource will ever overlap in time in a project.
The key to resource mapping between Project and Excel is;
client - Client approval
author - Author approval
writer - Writing
editor - Editing
studio - Studio
produtction - Production
all other resources - Third party approval
The project description in Excel is read from the MS Project file.
Each Project file task has the previous task as its predecessor.
The macro should ask the user the date range they wish to build the view for (default – 3 months)
14 freelancere byder i gennemsnit $837 for dette job
Dear Prospect, We just completed a project that involves programming excel macros for Stock analysis today. We can start your project on 6th July 2005. Please contact us asap Warm regards Francena