Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media

    I need Excel VBA programmer

    - or -

    Post a project like this
    3237
    £10/hr(approx. $12/hr)
    • Posted: 9 years ago
    • Proposals: 6
    • Remote
    • #514814
    • Completed
    David D.
    David D.
    MS Access, Excel VBA Application Developer and Data Tamer.
    Top Endorsed
    United Kingdom Holmes Chapel
    Les K.
    Les K.
    IT Support, ACCESS, EXCEL & VBA Developer
    Top Endorsed
    United Kingdom City of London
    Bjorn K.
    Bjorn K.
    system developer, VBA programmer
    Sweden Goeteborg
    BrightView Design S.
    BrightView Design S.
    Database Dvelopment, .Net programming, Quantitative Finance Research
    Russian Federation Syktyvkar
    Abhijit A.
    Abhijit A.
    Magento, Drupal and Wordpress Specialist
    Top Seller with earnings over £100kTop Endorsed
    India Kolkata
    Ethan W.
    Ethan W.
    SENIOR WEB DESIGNER/ANIMATION/Portuguese Translator/FRENCH TRANSLATOR/GERMAN TRANSLATOR
    Top Endorsed
    India Mumbai
    15980835495382454457743473174555014
    David D.Les K.Bjorn K.BrightView Design S.Abhijit A. + 1 other have already sent a proposal.
    • 0
    • 0

    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
    •  
    •  
    N R.
    N R.
    100% (16)
    Projects Completed
    27
    Freelancers worked with
    17
    Projects awarded
    42%
    Last project
    5 Jul 2022
    United Kingdom

    New Proposal

    Login to your account and send a proposal now to get this project.

    Log in

    Clarification Board Ask a Question

      There are no clarification messages.
    3237
    £10/hr(approx. $12/hr)

    - or -

    Post a project like this
    N R.
    N R.
    100% (16)
    Projects Completed
    27
    Freelancers worked with
    17
    Projects awarded
    42%
    Last project
    5 Jul 2022
    United Kingdom

    Related project Searches


    advice/consult and guidance VBA programming language workbook

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2023 People Per Hour Ltd
    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