Find Jobs
Hire Freelancers

Custom Excel Macros Worksheet

$30-250 USD

Completed
Posted almost 8 years ago

$30-250 USD

Paid on delivery
Each day, I have 2 excel reports that is sent to me. At the end of the month, I have another worksheet that needs specific data from the daily reports to be populated in. The daily reports will be saved with a specific date and name into a designated folder. I need to have a macros button within the monthly report worksheet that when clicked, it will populate the necessary data from each date.
Project ID: 10483344

About the project

43 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
Awarded to:
User Avatar
$100 USD in 1 day
4.9 (251 reviews)
7.7
7.7
43 freelancers are bidding on average $95 USD for this job
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$100 USD in 3 days
5.0 (471 reviews)
8.0
8.0
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).
$95 USD in 4 days
4.9 (347 reviews)
8.0
8.0
User Avatar
Hi, my name is Sevinc. I read your "Custom Excel Macros Worksheet" project descriptions carefully before bidding.I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
$85 USD in 3 days
4.9 (286 reviews)
8.0
8.0
User Avatar
Hi, I can add to your monthly report a button that will popup the breakdown of the specific value. I recommend you to do it in Pivot Table by adding the daily information to central excel file with the Pivot Table. About ME: I am a specialist in financial information and an expert in Microsoft Excel, Pivot Tables and VBA. With these experience and knowledge, I have built for over 25 years many Financial/Costing Reporting Systems and business plans for enterprise and global companies. Areas of expertise:  Developing of consolidated financial statements applications, Business plans, feasibility studies and measurement reporting tools for global companies  Specialize in information technology and expert in Microsoft Excel Pivot Tables and VBA  Business valuation (NPV, IRR, DCF)  Multi-national business  Budget Development & Management  Business expansion and start-up  Served as CFO, Comptroller, and Chief Accountant at global parent companies  Extensive experience with accounting, consolidating, forecasting, budgeting, and costing  A systemic perspective and ability to transport and process administrative improvement  Excellent awareness of service and human relations  Implementation of information systems in organisations and companies (accounting, payroll, treasury, budgeting and control, MF, ERP, Venture Capital system, CRM, etc.)
$277 USD in 3 days
4.9 (93 reviews)
7.5
7.5
User Avatar
I can do it for you quickly and exactly
$70 USD in 3 days
4.9 (119 reviews)
7.1
7.1
User Avatar
Hi Sir, Its a trivial task to read the required data from daily sheets. I can write a VBA macro to do the job. Please share the sheets so I am have a look. Thank you, Usman
$130 USD in 1 day
5.0 (70 reviews)
6.9
6.9
User Avatar
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I've done a lot of similar work. 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 let me know the details. 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/
$100 USD in 2 days
4.8 (177 reviews)
7.1
7.1
User Avatar
Hello there, I am an expert in Excel macros as you would see in my work history here on freelancer and can create the macro that will read the daily files and generate the monthly file as required. If you could share some sample data files, the information that needs to be imported from them and the desired report structure, I would be able to complete the project and send the spreadsheet back to you in a couple of days. Please drop a message to me if you would like me to work on this project for you and we may discuss the next steps. Look forward to hear from you and thank you for considering my bid Best Regards, Rishi Automyze Consulting - The Business Process Automation and Optimization Experts
$111 USD in 5 days
4.8 (96 reviews)
6.5
6.5
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 75 projects, almost 70+ are complex VB/VBA/.Net/Webscrapping projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Webscrapping (Amazon / Aliexpress / eBay), VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$64 USD in 3 days
4.9 (77 reviews)
6.1
6.1
User Avatar
Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed several projects like this. For evidence you can see my profile. I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. -- Kinds Regards, Mehedi Hasan.
$144 USD in 3 days
4.8 (126 reviews)
6.2
6.2
User Avatar
Hi, I use to merge, sort, consolidate and do many more similar operations on spreadsheets almost daily. So I am sure i can help you with a clean and good solution to your requirement. Please contact to chat about. Review my profile and comments from my clients as a reference.
$50 USD in 5 days
4.9 (57 reviews)
6.0
6.0
User Avatar
I am a postgraduate in finance (MBA) with more than 5 years of experience having expertise in Excel, VBA. Currently working in an MNC Analytical company on a large financial model including dashboards and presentations to board for a leading US bank. I can help you with your current requirement as well as any further requirement with low cost of work. I can deliver the work in lesser time than others while maintaining the superior quality of work.
$130 USD in 2 days
4.9 (50 reviews)
5.9
5.9
User Avatar
Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 3 years. I have worked on lot of advance Excel based process automation using VBA macros and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.
$150 USD in 3 days
4.9 (18 reviews)
5.7
5.7
User Avatar
I have excellent command on MS Excel and have done similar tasks of consolidating data from various sheets before. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Build a reservation system - Build a complex shift allowance calendar and calculator You can see the reviews of the same in my profile
$80 USD in 2 days
4.8 (81 reviews)
6.0
6.0
User Avatar
I have gone thru the project description and able to create a macros button within the monthly report worksheet (using Excel VBA) that when clicked, it will populate the necessary data from each supplied date.
$60 USD in 3 days
4.9 (65 reviews)
5.4
5.4
User Avatar
A proposal has not yet been provided
$250 USD in 5 days
4.8 (22 reviews)
5.5
5.5
User Avatar
Dear Employer, I am an excel developer with the Retail business / Supply Chain / Inventory control / Replenishment Planning and Sales Data analysis back ground. I always use Excel both excel standard and VBA coding to design the simulation model for the business and also create the dynamic Spreadsheet for users to use. You can see more of my profile and expertise here: my project feedback in http://www.freelancer.com/users/feedback_2698784.html I have read your requirement, it is what I am doing every day and every month, I believe I can do this task with best as you wish. Kind regards, pichart Y.
$130 USD in 2 days
5.0 (40 reviews)
5.5
5.5
User Avatar
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start - message me for further discussion. Waiting to hear from you. with thanks and regards
$98 USD in 3 days
4.6 (43 reviews)
5.6
5.6
User Avatar
Hi there! I'm a web developer.I'm get bachelor IT certificate on 2013.I have 3+ year in web development.I provide services with enthusiasm, creativity, pay until you are satisfied with my quality services and reach your purposes. My Services: Website design and development. Responsive website. Excel fomulas - Dashboard design -VBA Programming. Data entry -product upload-CMS- Virtual Assistant. Html-Css-javascript. PHP-Wordpress-C# Unity. Software Testing. Hire me for: - Fast turnaround time - satisfy 100%.Lifetime support. - Working everyday. - realtime responding.
$150 USD in 4 days
4.8 (50 reviews)
5.1
5.1
User Avatar
Hi, I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am an experienced MS Office, VBA, Graphic Designing, PDF and Data Entry expert. Your kind response is being awaited.
$85 USD in 3 days
4.9 (28 reviews)
4.5
4.5

About the client

Flag of UNITED STATES
Los Angeles, United States
5.0
12
Payment method verified
Member since Sep 10, 2013

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.