Find Jobs
Hire Freelancers

Automatically fill worksheets in Excel based on a data overview (write a Macro)

$250-750 USD

Completed
Posted over 4 years ago

$250-750 USD

Paid on delivery
Intro: We have an (i) overview sheet which is filled in every day for workorders on our building site. The overview sheet is a collection of workorders whereto we assign names and performed hours and consumption of materials. Goal: We want to automatically transfer the data from (i) overview sheet to an individual (ii) Day working report. Basically a macro needs to be written to run on the (i) overview sheet which then creates a number of worksheets in the excel file. I have included an example in annex
Project ID: 21128330

About the project

38 proposals
Remote project
Active 5 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
Hi, I ll code the macro to read and treat data in the overview and fill and generate the reports. I require a short discussion to clarify few things and I m ready to start. Thanks (Also feel free if you want to talk in French)
$350 USD in 4 days
5.0 (236 reviews)
7.7
7.7
38 freelancers are bidding on average $404 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 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, Sandeep
$350 USD in 6 days
4.9 (282 reviews)
7.9
7.9
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro that will transfer data from the overview tab to individual sheets. I plan to use VBA code to accomplish this. The Excel file will run on PCs. Moreover, the code will check if the job's individual sheet exists and it will create it if not. The tabs will be colored differently so they are distinguishable. I can use my coloring or you can set their order. I will charge you $450* and can deliver within three days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel, and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 320 projects successfully in six years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$450 USD in 3 days
4.9 (123 reviews)
6.8
6.8
User Avatar
With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and macro/VBA development. I read your project descriptions carefully. I checked the attached files as well… I can write the macro as requested. Kindly get back to me if you wish to proceed. I am available to start your project immediately. Looking forward to discuss further and work on your project.
$350 USD in 10 days
5.0 (89 reviews)
6.2
6.2
User Avatar
Hello, I have gone through your project description and understood what has to be done in this task and can give you a complete assurance that I can do the job. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assist you in getting this task done with more focus on quality and getting it delivered on time. Regards, Nidhi
$500 USD in 7 days
4.9 (113 reviews)
6.3
6.3
User Avatar
Hello, I have substantial experience in excel and VBA, and I will be happy to assist you with your data transferring job. Please send me a message so that we can discuss it in detail. Looking forward to hearing from you, BR, Razvan
$300 USD in 7 days
5.0 (15 reviews)
6.0
6.0
User Avatar
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$250 USD in 3 days
4.9 (50 reviews)
5.6
5.6
User Avatar
$ 250 Only---- In just 1 day ------- Excel VBA Macro & Formula Expert ------ 100% satisfaction first, then payment.
$250 USD in 1 day
4.9 (85 reviews)
5.2
5.2
User Avatar
hi, good day, im interested in your project about writing a macro(VBA) to produce multiple worksheets according to the workorders. I have rich experience in excel (advanced formulas, VBA, Macro,....), and I do my best to save your time and pocket. Please feel free to contact me. Services: # Accuracy # Customer satisfaction is my first "Priority" # Time Commitment # Availability Thanks, Shahin
$400 USD in 4 days
5.0 (42 reviews)
5.2
5.2
User Avatar
Hi, I can write a macro for you, so that, it will open up all individual Excel files automatically, copying specific data you want and paste it in the Overview Excel (or copy entire sheets into the overview workbook as a individual new sheet)
$250 USD in 3 days
5.0 (12 reviews)
4.7
4.7
User Avatar
Hi, I am an excel VBA expert and have developed 1500+ software till now. I read through your project description and went through the instruction file. Im guessing the number of workers would increase/decrease so i will take that into consideration. Please go through my profile and reviews so that you can be confident about me. Hope to chat with you soon mate! Thanks Sajid
$250 USD in 3 days
4.0 (52 reviews)
5.4
5.4
User Avatar
Hi. thanks for your posting. I'm very happy to have a chance of bidding your project. I have experience in development of the projects like yours If you hire me, I'll do my best for your project and finish greatly in a short time. I'm sure I can satisfy for you as you want. Best regards.
$500 USD in 7 days
5.0 (2 reviews)
3.0
3.0
User Avatar
Hello Sir, I am extremely good at excel and VBA program. I can develop the VBA macro for your process. I am looking forward to discuss further and working with you. Kind Regards Gopal
$250 USD in 3 days
5.0 (7 reviews)
2.4
2.4
User Avatar
I am professional with Ms Excel and VBA, I can complete this project within 7 days. Please message me to discuss on your project. Thank You.
$277 USD in 7 days
5.0 (1 review)
2.1
2.1
User Avatar
Hello According to our experience, this will be an easy job for us. We can prepare the project in less than a week for you. We recently started working as freelancers and we need to upgrade our rankings on the site by doing small projects. We hope you help us in this way and provide us with the advancement in this field. Please check our resume and portfolio. Be sure about the quality of us and consider your project DONE.
$300 USD in 4 days
5.0 (1 review)
0.4
0.4
User Avatar
I WILL DONE YOUR WORK WITHIN A TIME PERIOD. I HAVE A 2 YEAR EXPERIANCE IN MULTINATION COMPANY . PLEASE SEND YOUR PROPOSAL. I AM B.TEC. HOLDER IN COMPUTER SCIENCE BRANCH. THANKS JITENDRA VISHWAKARMA MOB. 7000581032
$250 USD in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I have experience in this work because I have worked on construction company for 4 years and I done such job like labor day work in excel sheet .
$250 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do this job and give you an efficient job that will be very acceptable and presentable. I and my team work on web development and mobile apps and I can assure you that you will never be disappointed"
$525 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
The job made me happy as because the skills required in the job matches with me properly. Nowadays there’s bunch of freelancers available who ensure you to work properly but they don’t keep their promises. Most people don’t even know the work strategy properly. By reading your job description what I have come to understand that you want someone who can complete the task faster and also with perfection. I have all the required skills that you posted in the description. As being a skilled data entry employee I would like to offer myself as a candidate for the job. It’s been almost 6 years I’m working with data entry, data importing, data exporting. In these 6 years I have worked with lots of people and companies which has made me a skilled and experienced data entry worker. My typing speed has also proven satisfactory to all my old clients. And I’m also okay with your time schedule so the time can’t do any harm in our work. For knowing more about my skills you are requested to visit my profile and read the satisfactory posts that are posted by my previous clients. Your job made me so curious that I just can’t wait to have the job and complete it quickly and properly. And I can assure that I’m the only data entry worker who can make you pleased by the work. So, all I want you to give me the opportunity to prove myself for the work.
$500 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Data entry job and capita work
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project.I Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Your project will be delivered on time with high standard. Assistance will be provided with number of clarifications until client satisfaction
$400 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BELGIUM
Kapellen (Antwerpen), Belgium
5.0
2
Payment method verified
Member since Jul 28, 2016

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.