
I need Excel VBA programmer
- or -
Post a project like this3930
£10/hr(approx. $13/hr)
- Posted:
- Proposals: 5
- Remote
- #514814
- Completed
Description
Experience Level: Entry
I require an excel VBA programmer for a little assignment .
I have an excel workbook which uses an xer file and loads up data into excel sheet . Everything is working fine all I need is to refine the VBA code to create a button which filters out a specific text from the data and draws the WBS for that matched text entries only . At the moment it draws the wbs for the whole project .
Basically, I have this excel workbook which I got from a friend. It loads up a xer (primavera-P6 file) and draws a WBS structure in excel of all the activates with the relevant columns. It also draws a dashboard alongside the WBS. The above Excel file does that using VBA modules. I have inserted a button named filter which I need to add the code so that when the xer is loaded in Excel. I can filter required information by pressing this button "Filter". For example, if this button is codded for the filtering a particular "activity name" text or string. It should search the temp table find all the activities which match that activity name and display/draw a new WBS according to the filtered activity-name information in a new excel sheet on the same workbook. The code does something similar and by pressing the Gantt chart button draw's a Gantt chart from the loaded xer file but I don't know how to modify the code to draw me another WBS with only filtered activities.
If you look at the VBA files its all commented. I also want a little report on completion about the adjustments in code.
Hope I explained well. Please do not hesitate to contact me for further quires.
Please advise .
Cheers
Naum
I have an excel workbook which uses an xer file and loads up data into excel sheet . Everything is working fine all I need is to refine the VBA code to create a button which filters out a specific text from the data and draws the WBS for that matched text entries only . At the moment it draws the wbs for the whole project .
Basically, I have this excel workbook which I got from a friend. It loads up a xer (primavera-P6 file) and draws a WBS structure in excel of all the activates with the relevant columns. It also draws a dashboard alongside the WBS. The above Excel file does that using VBA modules. I have inserted a button named filter which I need to add the code so that when the xer is loaded in Excel. I can filter required information by pressing this button "Filter". For example, if this button is codded for the filtering a particular "activity name" text or string. It should search the temp table find all the activities which match that activity name and display/draw a new WBS according to the filtered activity-name information in a new excel sheet on the same workbook. The code does something similar and by pressing the Gantt chart button draw's a Gantt chart from the loaded xer file but I don't know how to modify the code to draw me another WBS with only filtered activities.
If you look at the VBA files its all commented. I also want a little report on completion about the adjustments in code.
Hope I explained well. Please do not hesitate to contact me for further quires.
Please advise .
Cheers
Naum

N R.
100% (16)Projects Completed
28
Freelancers worked with
18
Projects awarded
49%
Last project
20 Nov 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies