Find Jobs
Hire Freelancers

Create MS Excel VBA code to produce Monthly Expense Report

$30-250 USD

Closed
Posted over 8 years ago

$30-250 USD

Paid on delivery
I need a Microsoft Excel VBA expert who regularly develops complex VBA code and has great attention to detail. I expect an expert will need to spend 5 hours of time to complete this project. There is a deadline we need to meet. This project needs to be completed within 2 days of commencing. I have a Microsoft Excel file that has thousands of expenses organized by department listed on one sheet and employee monthly salaries organized by department listed on another sheet. I need someone to develop the code to add up the expenses and report on the expenses in different ways. Some examples of what we need to do is as follows: - Who are our biggest suppliers and how much money do we spend with them? - What were our expenses during the prior quarter and have they increased or decreased this quarter? - What are our top 10 most expensive projects over the past 10 years? - What is the split between internal and outsourced expenses between departments? The expense data comes from many different people so there is often problems we need to automatically correct. Examples include: - One person using "Department 1" another using "Dept. 1" and another using "DEPT1" so we have a translation sheet to do an auto-replace - Some people forgetting to fill in fields such as "Department Manager Name". So we need to auto-populate that if the Department is "Department 1" then the Department 1 Manager's name is "Joe Smith" In order to make sure we pick up on all data entry errors we need to have another sheet which gives us the unique values. That way, a secretary can read through all unique values and notice "DEPT1" and "Department 1" and know he/she needs to add it to the translation sheet used to operate the auto-replace. We also need a sheet that shows the summary for each department's expenses. We can use the sheet to notice $0 expenses which will alert us to the fact that expenses might be missing. Finally, we need to help the secretary in generating the expense report by having a control sheet where he/she can select the expense report period (e.g. January 2015 to July 2015) and have only those expenses be reported on. This also needs to automatically update the text on the report. The format of the reports are fixed. The input fields are fixed. I will supply you sample data. You just need to write the code that does all the calculations.
Project ID: 9202338

About the project

50 proposals
Remote project
Active 8 yrs 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
50 freelancers are bidding on average $185 USD for this job
User Avatar
Hi, I am an Excel VBA expert and would be happy to take on your project. Please provide the Excel data file for me to have a look at. Regards, Arul
$250 USD in 3 days
5.0 (195 reviews)
7.2
7.2
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$211 USD in 3 days
5.0 (174 reviews)
6.7
6.7
User Avatar
I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I could send you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$180 USD in 3 days
4.8 (162 reviews)
6.9
6.9
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$150 USD in 7 days
4.8 (117 reviews)
6.5
6.5
User Avatar
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 260 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$150 USD in 2 days
4.9 (112 reviews)
6.2
6.2
User Avatar
Hello there, I am an Excel VBA expert as you would see in my work history here on freelancer. I reviewed the requirements brief that you shared and understand exactly what needs to be done. However, if you could share some sample data, I would be able to suggest a suitable spreadsheet structure for the same. Please drop a note to me and we may discuss the next steps. Look forward to hearing from you. Thanks and Regards, Rishi
$200 USD in 2 days
4.9 (124 reviews)
6.4
6.4
User Avatar
I can do it for you quickly and exactly
$150 USD in 3 days
4.9 (76 reviews)
5.8
5.8
User Avatar
Hello, I am Excel and VBA expert. Could you provide a sample data? Please note that I have 100% completion rate and 5-star feedback on projects.
$155 USD in 3 days
5.0 (61 reviews)
5.6
5.6
User Avatar
Hi, I would like to work on this project. I have worked on web services, data automation, data scrapping and database integrations all from excel VBA. Looking fwd for your response.
$222 USD in 2 days
5.0 (8 reviews)
5.3
5.3
User Avatar
Hello there. My name is Bruno Martins and I'm an Electrical and Computers Engineer. I'm experienced with this kind of work/reports and, for that reason, I believe I'm capable of delivering what you need within the timeline you require. For this project I'd develop the VBA code to run through your raw data in order to treat it and report as required. If you choose to work with me I'd like to view a sample data in order to analyse it and asure you that I can make it in time. Please feel free to review the feedback given to me by my employers. Best regards, Bruno Martins
$150 USD in 2 days
5.0 (61 reviews)
5.4
5.4
User Avatar
Hi, I am VB and GIS developer and well versed in Excel and programming of Excel using VBA or even developing Add-in for Excel using VSTO of .NET. I gave also courses in Excel for UN employees here in Palestine - Gaza. The attached image is screen shot for Add-in for Excel to integrate Excel with another application called MetaTrader4 to allow the users to trade from within Excel. This project is complicated and deal with many technologies and fields like calling underlying layer for communications and graphics to have dynamic charts and link to MS Access to store the actions by the user and finally controlling MetaTrader from Excel. I am ready to discuss and doing your project. Regards, Eyad
$1,105 USD in 15 days
5.0 (13 reviews)
5.1
5.1
User Avatar
I am experienced with VBA Excel implementations. I have several successfully closed projects with data automation, data entry forms, sorting, inserting processed data from several worksheets to another etc. I am aware about the requirements and can conduct the activities in the requested lead time.
$250 USD in 3 days
5.0 (7 reviews)
5.0
5.0
User Avatar
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. In my portfolio look at the screen of "Create sales and purchases database application". You will find the similarity.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$155 USD in 3 days
4.7 (15 reviews)
5.0
5.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
4.5 (64 reviews)
5.2
5.2
User Avatar
Sir/Madam, I am interested in your project. I have excellent expertise in Microsoft Excel and VBA programming. Programming has always been a challenging assignment, I have always taken challenges and accomplished it successfully. Your assignment involves data analysis and data validation tools using VBA which I can perform successfully. I can help you generate different types of report in Excel as per your requirements. For the issue of different people inputting different text (Dept. 1, Department 1, etc), I suggest using Drop Down boxes, which will solve this problem. Then, I can use conditional formatting to highlight key data which rises or falls below specific limits. (Issue $0). I can recommend many more suggestions for automation of your company business, which will increase your effectiveness and productivity. I assure you my complete support and service, and commit to meet the deadlines. Please consider my proposal and discuss with me your detail requirement. Prices are negotiable based on work requirements. Thank you, Yours faithfully, Saravana Prakash
$100 USD in 2 days
5.0 (22 reviews)
3.8
3.8
User Avatar
Hi, my name is Daniel, i am an excel expert and vb programmer. I am sure i can do this work just in a coupple of hours. My proposal: do this work with all your requirements just in a coupple of hours then send to you the draft and make the adjustment that you want until you be 100% satisfied.
$88 USD in 0 day
4.8 (13 reviews)
4.0
4.0
User Avatar
Hi there, I’d like to be considered for your bid. I am a software developer with a strong background developing excel, access related applications, including excel functions,active x objects, sql server as backend, data processing. I can design and develop excel, applications in quick time ensuring the final output is as per the precise requirement. Over 8 yrs I've worked in VBA technology and so I am accustomed to working with all sorts of excel, access related development. You can be sure that I will use my best skills to ensure the successful completion of the project. I highly value professionalism and hold myself strictly accountable to represent client's profile. I aim to form a long term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Vinay
$150 USD in 2 days
4.8 (9 reviews)
4.1
4.1
User Avatar
Hi, I have a macro ready for the job. Please contact me for further details of your project. Thanks!...............................................................................................................................................
$111 USD in 2 days
4.6 (12 reviews)
3.8
3.8
User Avatar
Hi, I am an experienced Excel development professional with over a decade of history delivering projects that meet or exceed my client's expectations. I would like the opportunity to do the same for you. I focus on functionality, ease of use and design. Many of my projects included working with and cleaning large datasets from multiple sources. In addition, I have developed formula based logic structures which add value by improving the underlying process flow. My solutions are primarily based on a combination of formulas, pivot tables and simple VBA code to ensure my clients have the best level of control and post delivery. My focus is on continuing to provide tools that are easy to use to answer difficult questions. I will solve your data entry issues with a master list for translation, where I will highlight those entries without a match in your database (exception report). In addition, I will also help you see departments without expenses by department. I will provide clear instructions, including follow-up to your team to ensure the reporting is easy to use and effective. Please let me know if you have any questions and please see my reviews. Thanks. -Kevin
$250 USD in 3 days
5.0 (6 reviews)
3.5
3.5
User Avatar
Hi. I am writing VBA code in Excel for different analyses and data restructuring task on a daily basis. I can make the task once or implement a makro that you activate with a clockable button to refresh the analysis after a while. I could do the job for you easily!
$100 USD in 1 day
5.0 (5 reviews)
3.6
3.6

About the client

Flag of UNITED STATES
Cambridge, United States
4.9
6
Payment method verified
Member since Jun 22, 2015

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.