MS Excel Macro Required

I work in an environment where my customers (Project Managers) use a standalone version of MS Project 2003.? At present, no enterprise tool is available to us.? On that basis I am looking to **develop a macro (to be used in Excel)** that high-lights and reports cross-project dependencies. ? Project specification and template of the final output is attached for your information. ## Deliverables Update: ? **Error Message Criteria** ? **Duplicate Gives** Two or more “Give?? selections (in the Give/Get Identifier column) with the same value in the “Give/Get Reference?? field ? Error message to generate: “Duplicate Gives?? ? **Early Get** A “Get?? selection (in the Give/Get Identifier column) that has an earlier date (in the Finish column) than its matching “Give?? date (in the Give/Get Reference column) ? This will show negative lag. ? Error message to generate: “Early Get?? ? **Early Give** A “Give?? (in the Give/Get Identifier column) that has an earlier date (in the Finish column) than its counterpart “Get?? (in the Give/Get Reference column) ? This will show positive lag. ? Error message to generate: “Early Give?? ? **No Associated Get** A “Get?? (in the Give/Get Identifier column) that has no counterpart “Give?? (in the Give/Get Identifier column) ? Error message to generate: “No Get Value?? ? **No Associated Give** A “Give?? (in the Give/Get Identifier column) that has no counterpart “Get?? (in the Give/Get Identifier column) ? **No Error** A “Give?? (in the Give/Get Identifier column) that has a, or multiple, counterpart “Get??/s (in the Give/Get Identifier column) with a matching date in the Finish column ? Error message to generate: “No Error??.? The entire row should be high-lighted in green. ? **No Get Value** A “Get?? (in the Give/Get Identifier column) that has no value assigned in the in the “Give/Get Reference?? column ? Error message to generate: “No Get Value??. ? **No Give Value** A “Give?? (in the Give/Get Identifier column) that has no value assigned in the in the “Give/Get Reference?? column ? Error message to generate: “No Give Value??. ? Descoping the following: The "Late Get" report? is the same as "Early Give" report The "Late Give" report? is the same as 2Early Get" report ? As such, the “Late Get?? and “Late Give?? reports are no longer required.**** **** ** ** **Background** ? I work in an environment where my customers (Project Managers) use a standalone version of MS Project 2003.? At present, no enterprise tool is available to us.? On that basis I am looking to **develop a macro (to be used in Excel)** that high-lights and reports cross-project dependencies. ? In short, the process works on the following premise: ? Where Project A has a dependency on Project B it is managed in MS Project with the inclusion two milestones (one in each schedule), these are: ? | **Project** | **Task Name** | **Dependency Type** | **Unique Dependency Code** | | Project A | Give ??" Outgoing Dependency | Give | ProjectA-01 | ? | | Project B | Get ??" Incoming Dependency | Get | ProjectA-01 | ? | ? **Requirement** ? Whilst I have created the macro that extracts, collates and exports the data from MS Project into MS Excel automating the analysis function is beyond my means. ? On that basis I am looking for someone that can develop a macro in Excel that can: ? 1. Format data 2. Group and sort data 3. Assign a value in a new column depending on a pre-defined set of criteria, the values to be assigned are: ·? ? ? ? ? ? ? Duplicate Gives ·? ? ? ? ? ? ? Early Get ·? ? ? ? ? ? ? Early Give ·? ? ? ? ? ? ? Late Get ·? ? ? ? ? ? ? Late Give ·? ? ? ? ? ? ? No Associated Get ·? ? ? ? ? ? ? No Associated Give ·? ? ? ? ? ? ? No Error ·? ? ? ? ? ? ? No Get Value ·? ? ? ? ? ? ? No Give Value 1. Generate the following reports and metrics: ·? ? ? ? ? ? ? Summary ·? ? ? ? ? ? ? Errors Count ·? ? ? ? ? ? ? Duplicate Gives ·? ? ? ? ? ? ? Early Get Count ·? ? ? ? ? ? ? Early Give Count ·? ? ? ? ? ? ? Late Get Count ·? ? ? ? ? ? ? Late Give Count ·? ? ? ? ? ? ? No Associated Get Count ·? ? ? ? ? ? ? No Associated Give Count Whilst the above may appear vague I have attached a template that demonstrates what I’m requiring.? This also shows the look-and-feel of the spreadsheet I’m requiring. ? **Timescales** ? Required within the next fortnight or so.