VBA Macro needed
$30-250 USD
Pagato alla consegna
Hi there,
To implement this project you will need access to MS Project and Excel.
I need someone to write a VBA/macro that would pull information on testing activities from an MS project schedule into an excel workbook, to populate a simple report within the excel document.
The MS Project schedule contains several projects, up to 20 projects at a time. I would like to know when the following testing activities are planned to occur and be completed on projects to determine if there any scheduling conflicts exists.
The testing activities are titled: SIT, UAT, QA and IV&V. And they are consistently titled across projects. So the schedule of every project will contain activities called SIT, UAT, QA and IV&V (as shown below).
A testing conflict occurs when similarly titled activities occur at the same time (or at overlapping times) across two or more projects. So if two projects are planned to do SIT at the same time, this creates a conflict.
The macro should go thru each line of activity in the project schedule, and when it encounters any of the above-mentioned testing activity, pull information on the project name, system name, test name, % work complete, duration, planned start and finish dates, actual start and finish dates (see list of info to be pulled below).
Project Name
System Name
Test Name
% Work Complete
Duration (Days)
Planned Start
Planned Finish
Actual Start
Actual Finish
Conflict
This info pulled into the excel workbook should then be used to populate the tables in the attached excel report.
Note: Within the table within the Testing Data tab, the testing information is grouped in the table by the Test Name. So all SIT tests are grouped together etc.
If interested in undertaking this project, I can provide more clarity/ answer any questions.
Rif. progetto: #23944139
Info sul progetto
Assegnato a:
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this easily due to my experience with VBA. It will be quick and accurate. If interested, we can discuss this further on Altro
7 freelance hanno fatto un'offerta media di $148 per questo lavoro
I can do the job and I can start right away! I have extensive experience in project scheduling with Ms Project (in large engineering mechanical engineering projects), also a lot of experience in VBA automations. I wou Altro
I have decades of experience with Excel macros and Excel. I m also skilled in Microsoft project. If awarded I can deliver the project
Hello. My favorite skill is Data processing and I am an expert in VBA & Excel. So I am very interested in your project. If you want to see my skills, please check my profile. I will do my best. We can discuss more deta Altro
Hello sir/ma, I'm interested in taking this task up for you. I'm a professional and also have good command over MS Excel especially pivot table, charts, advanced formulas, formatting, Excel VBA, R Programming Language Altro
