Find Jobs
Hire Freelancers

MS Project VBA for Report Automation -- 2

$30-250 AUD

Closed
Posted 10 days ago

$30-250 AUD

Paid on delivery
I am in need of a professional who has experience using VBA in MS Project to automate the process of generating project summary reports. So the person MUST have Ms Project experience to understand how project constructs data. Key tasks include: 1. Utilizing VBA to automate the generation of project summary reports. 2. These reports must provide a list of all tasks and their current status 3. in particular how to create a table of all tasks related to a Milestone - similar to Task path function for predecessors. The ideal freelancer for this project should possess strong skills in VBA and Microsoft Project. They should have a proven track record in automating and streamlining reporting processes. Previous experience in project management reporting is ESSENTIAL. I'm looking for someone who understands project progress reporting and can deliver efficient, accurate results. If it turns out that it is not possible to achieve the type of reporting in MS Project then i will consider outputting the data to Excel, and creating suitable dashboards in Excel. (I might also later on ask to repcate these dashboards in Powerbi, but at the current project we do not have Powerbi available)
Project ID: 38029137

About the project

35 proposals
Remote project
Active 4 days ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
35 freelancers are bidding on average $153 AUD for this job
User Avatar
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$180 AUD in 4 days
4.9 (599 reviews)
8.5
8.5
User Avatar
Hi there! As I have read, I see you need help automating project summary reports using VBA in MS Project, and I could help you! With my extensive experience in VBA and Microsoft Project, I am well-equipped to automate the generation of project summary reports efficiently and accurately. I understand project management principles and reporting requirements, ensuring that the reports provide comprehensive information on all tasks and their current status. I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 projects done here on this platform. I offer unlimited revisions and I don't require any payment in front. I always meet delivery deadlines working until I get the desired results. I know all the most used softwares to do this project specifically, I could even give you some other options in case you think is better to use other tools. Send me a message so I can show you my previous work and we can discuss more. Respectfully, Giovanni.
$30 AUD in 1 day
4.9 (58 reviews)
6.9
6.9
User Avatar
Hi, About this gig Are you in search of a highly skilled Microsoft Excel expert proficient in automated solutions encompassing Excel VBA, Excel formulas, Excel macros, functions, Excel dashboards, and Pivot tables? Look no further, as you have arrived at the right place! At EXO Automations, I offer a comprehensive range of solutions tailored to meet your needs: Excel Automation through Excel VBA and Excel Formula Interactive and Dynamic Excel Dashboard MS Excel User forms, Charts & Graphs Automatic Invoicing, Sales Orders, Payroll using Excel vba Data Analysis and Web Scraping Custom Excel Spreadsheets/Templates Complex Excel formula Google Sheets Expert (Google Spreadsheets) and much more
$220 AUD in 7 days
5.0 (20 reviews)
5.9
5.9
User Avatar
Hello there, Coming from an extensive background in data management and processing, I am confident that my expertise will meet the requirements of your project. With 5 years of experience in excelling at Data Entry, Excel and Visual Basic programming, I believe I possess the essential skill set necessary to streamline and automate your project's summary report generation process. My experience extends to VBA automation to create well-structured data tables - a valuable asset for your need of generating a Task-related Milestone function. Can we talk now? Waiting for your valuable reply! Regards, Ritika Kumari
$150 AUD in 3 days
4.8 (118 reviews)
6.1
6.1
User Avatar
With over 10 years of experience in excel usage and an ACCA qualification, I have expertise in all areas of Excel, I can provide you with efficient, accurate, and insightful solutions to your data-related challenges. My Excel services include the following: Financial modeling: As an ACCA qualified professional, I have extensive experience in creating financial models in Excel. I can help you create complex financial models, including cash flow projections, discounted cash flow analysis, and financial statement analysis. Data analysis and visualization: I can perform various types of data analysis, including statistical analysis, data modeling, and regression analysis, and visualize the results using charts and graphs. I have worked with large data sets and can help you summarize and present your data in a meaningful way. Reporting and dashboards: I can create custom reports and dashboards to help you visualize and analyze your data, and make informed decisions based on the insights gained. I can also design interactive dashboards that allow you to explore your data in real-time. My development process includes an initial consultation to understand your requirements and objectives, followed by designing and implementing customized solutions to meet your specific needs. I am committed to delivering high-quality services and ensuring customer satisfaction. Please don't hesitate to contact me. Best regards,
$250 AUD in 2 days
5.0 (50 reviews)
5.2
5.2
User Avatar
As a project management veteran with extensive experience in using Visual Basic for Apps and Excel, I am uniquely equipped to take on your project and deliver the reporting solution you need. When it comes to MS Project, my sophisticated understanding stems from direct experience with data assembling and automation, which aligns perfectly with the tasks you've detailed. Having long been involved in project management, I have a solid grasp of the nuances that define effective project progress reporting. This includes not only automating project summary reports, but also recognizing and surfacing key insights such as task status and task path information as it pertains to milestones. My CV is engulfed with project-based roles where accuracy and efficiency were paramount, making me the ideal candidate for this task. Additionally, my proficiency extends to Excel – should we find that MS Project's functionality is limited – where I am adept at creating dynamic dashboards. As you've mentioned the possible future requirement of using PowerBI, I'm ready for any eventuality with my ability to adapt and learn new tools swiftly. My aim is not only to automate your reporting but also deliver data visualizations that can be easily understood and actionable. So, in choosing me, you'll gain an experienced pro who is not confined by a singular skillset, but rather one who continues to grow for better delivery each time.
$140 AUD in 7 days
4.9 (7 reviews)
5.0
5.0
User Avatar
Hi there! As a professional and dedicated freelancer, I understand the value of accurate and efficient data entry. My expertise in Data Entry, Data Processing, and Excel will surely prove useful for this project. I have an excellent command over Power BI and can help you extract your data exactly the way you see it on the platform. In line with your goal to download the Excel file with utmost precision, I can assure you that my meticulous attention to detail will ensure a flawless transfer of all your data. Moreover, I have a strong understanding of how Power BI functions, which helps me maintain data integrity while exporting. Finally, my commitment to client satisfaction means that I will be available 24/7 for any queries or changes you might require. We'll be able to work closely together during the project, guaranteeing not only a successful transfer but also a pleasant collaboration experience. Choose me for this project and let's achieve your goal together! Thanks
$30 AUD in 1 day
5.0 (36 reviews)
3.9
3.9
User Avatar
Being a full-stack web developer and digital solutions provider, our team at BN-Droids Digital Services is well-equipped to handle your unique project requirements. With our expertise spanning across VBA, MS Project, Excel, and even Excel dashboards, we can ensure robust and efficient reporting automation that meets your specific needs. Drawing from my three years of experience in the industry, I have successfully executed numerous data-driven projects, demonstrating my proficiency in providing accurate and error-free outputs. We fully comprehend the intricacies of project management reporting and understand how significant it is to maintain data integrity while automating the reports. Knowing that adapting to uncertain situations sometimes arises, we are also proficient enough to output the data to Excel if necessary, without compromising on quality or timeliness. Believe me, Our team can effectively replicate any such dashboard in PowerBI once it becomes available for this project. At BN-Droids Digital Services, we consider client satisfaction as our utmost priority - ensuring your vision turns into reality exceeding expectations. Together with my team's expertise in VBA, MS Project, and Excel automation, we are best-suited to transform your project reporting process into a streamlined one delivering accurate and insightful summaries. Contact us now for an interactive and polished project reporting solution!
$30 AUD in 7 days
4.9 (12 reviews)
4.0
4.0
User Avatar
With a proficiency that extends beyond graphics design and web development, I have been utilizing VBA for more than a decade now. My deep understanding of Microsoft Project makes me ideally positioned to deliver the project summary reports you need. Over the years, I've built VBA scripts that automated a wide array of reporting processes, which aligns perfectly with what you require. A key factor that distinguishes me from other freelancers is my familiarity with project management reporting. I understand how critical it is to provide accurate, easily-understandable summaries and how even minor overlooks can adversely impact the entire project ecosystem. Suffice to say, I do not compromise on precision or quality. Though MS Power BI is not available at the moment, if you require dashboards in Excel down the line, I am equally well-versed in creating suitable outputs there. My past works encompass tasks similar to extracting and representing data, which make me adaptable to this transition if needed. Ultimately, being deadline-oriented that respects time and budget constraints without compromising on quality, I intend to take your project forward with earnest care and dedication.
$288 AUD in 2 days
4.9 (3 reviews)
3.7
3.7
User Avatar
Hi There , I am much interested to start work on your project " MS Project VBA for Report Automation - I have lots of experience in designing and i am sure i can do your project with 100% job satisfaction. I have great skills with tools such as Photoshop, Illustrator, In-Design and Power-point etc. Here you can find some more similar projects on my freelancer portfolio. Feel free to ask me any questions and if you can be more specific about your project that would be great. I am looking forward to being working with you on the project . Thank you
$140 AUD in 2 days
5.0 (1 review)
3.3
3.3
User Avatar
Having worked with MS Office suite for over a decade, I have in-depth knowledge and expertise in using VBA in Excel. Not only have I automated complex reporting processes involving tasks and milestones with large datasets, but I have also used my data processing skills to output this information into visually appealing and easily understandable dashboards. My profound understanding of Power BI could also come in handy if we need to migrate this project over. I've successfully implemented Power BI on various projects and can use its capabilities to replicate or even enhance the dashboards we create in Excel. Moreover, I believe my experience with SQL server and data processing could add another layer of value by enabling us to integrate other data sources if needed. Lastly, I understand how vital a comprehensive project progress report is and the insights that it can provide. My nearly two decades of experience across industries has given me a deep understanding of the nuances involved in project management which includes preparing precise, on time and insightful reports which are able to quickly spot inefficient areas requiring immediate attention or opportunities for time/resource optimization. Let me bring this value to your project by automating your reporting process with efficiency and accuracy.
$140 AUD in 7 days
5.0 (9 reviews)
3.2
3.2
User Avatar
Hey Simon C., I have carefully read through your project requirements for automating project summary reports using VBA in MS Project. With my expertise in Visual Basic, Data Processing, and Excel, I am confident in providing a solution tailored to your needs. To achieve the desired outcome, I will first analyze the project structure in MS Project to understand the data constructs. I will then develop VBA scripts to automate the generation of detailed project summary reports, including a comprehensive list of tasks and their current status. Additionally, I will work on creating a table specifically for tasks related to milestones, ensuring efficient reporting. My experience in VBA and Microsoft Project, coupled with a strong background in automating reporting processes, makes me well-equipped to handle this project effectively. I am committed to delivering accurate and streamlined results that meet your expectations. Please feel free to initiate the chat to discuss further details. Best regards
$30 AUD in 1 day
5.0 (2 reviews)
3.0
3.0
User Avatar
Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?
$65 AUD in 1 day
4.5 (7 reviews)
2.3
2.3
User Avatar
Hi there, I have an M.B.A in Business and Finance, and more than 10 years of experience as a business consultant, I have helped clients take off their businesses and reach new heights by optimizing the strategy, research, analyzing their market and competitive position, and creating a clear and compelling business plan to articulate their opportunity. I can surely assist you in writing a business plan. While working on this, I will ensure to provide extensively researched content, which will specifically include an Executive Summary, a Business Overview, an effective Operations Plan, Market analysis and Cost Analysis, Product and Services description, Sales and Marketing strategies, a Competitive Analysis, Management Team, Financial Plan and estimated Projections. My top priority will be helping you with a high-quality write-up for this business plan. As a professional business strategist, carrying a decade of experience in the writing industry, I will be crafting a perfect plan for you that helps you focus on both short-term and long-term goals, making sure your ideas succeed. I have had the pleasure of working on several similar projects with multiple clients over different freelancing platforms; I can deliver quality work to tight deadlines. You can see an example of one of those projects in my portfolio. Feel free to engage me by sending a single text. Regards,
$30 AUD in 1 day
5.0 (1 review)
1.8
1.8
User Avatar
Yes I have read your project and understood requirements but have some doubts. please message me so we can discuss in detail. i am ready to start work.
$140 AUD in 7 days
5.0 (1 review)
1.0
1.0
User Avatar
Hi, ------SCRAPING, AUTOMATION EXPERT------- Please check my portfolio, I have scraped and created automation script for tons of websites. Visual Basic for Apps, Microsoft Project, Excel, Data Processing and Visual Basic are my core skills. I am always ready and you will get the best result you ever have.
$200 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
As a talented Full Stack Developer with versatile skills ranging from programming languages to backend technologies, I've assimilated hands-on experience with all processes of your project including your core objective - Automation and Reporting. While I don't have direct experience in MS Project-based VBA, my broad comprehension of Visual Basic combined with my ability to quickly learn new systems ensures that I'm more than capable of delivering what you require. In the past, I have effectively leveraged automation and reporting tools to streamline complex data structures and create summary reports. This skill set coupled with my experience in front-end frameworks like React and Angular makes me adept at transforming raw data into informative dashboards, even without PowerBI (if needed). My previous background as a Project Manager also gives me the insider perspective to design systems that clearly present crucial project information for management decisions. Trust me, combining my strong communication skills, collaborative approach, and deep understanding of effective project management reporting, our partnership will not only yield efficient and accurate results but will lead to an improved understanding of your project's progress. Let's bring your vision to life!
$140 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I hope this message finds you well. We are currently seeking a professional with experience in VBA and Microsoft Project to automate the process of generating project summary reports. Key Tasks: 1. Utilizing VBA to automate the generation of project summary reports. 2. Creating reports listing all tasks and their current status. 3. Specifically, creating a table of tasks related to milestones, similar to the Task Path function for predecessors. The ideal candidate should possess the following skills and experience: - Proficiency in VBA and Microsoft Project. - Proven track record in automating and streamlining reporting processes. - Previous experience in project management reporting is essential. - Understanding of project progress reporting and the ability to deliver efficient, accurate results. In case it's not feasible to achieve the desired reporting in MS Project, the candidate should be open to outputting the data to Excel and creating suitable dashboards. There may also be future opportunities to replicate these dashboards in PowerBI, although PowerBI is not available for the current project. If you have the expertise and experience required for this role, we would love to hear from you. Please reply to this email with your resume and any relevant work samples. Thank you for considering this opportunity. We look forward to potentially collaborating with you. Best regards
$140 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
⚛️ Expert of Excel, ExcelVBA, Macro, Formulas, Algorithm HERE ⚛️ Hi Client! I am Coco, rich experienced software expert from Malaysia. I noticed that I am appropriate to this project. As a skillful software developer, I have rich experience with Excel, ExcelVBA, Macro, Formulas, Algorithm and built many projects like this. I promise I will finish this project with high quality on time. I hope you to contact me so that we have a full discuss with the project. Thanks. Best regard!
$30 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
How are you today? I have ✅ Full Experiences in Excel VBA✅. I read your requirement carefully. I think that it is better to use Excel VBA for implement your idea. Hope to discuss with you soon. Thanks for reading my words.
$180 AUD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Sydney, Australia
0.0
0
Payment method verified
Member since Mar 27, 2024

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.