Find Jobs
Hire Freelancers

Build Macros in an EXCEL sheet to automatically populate data from a Master Sheet

$30-250 USD

Completed
Posted about 8 years ago

$30-250 USD

Paid on delivery
See attached document tracking Sheet. The first sheet is the master schedule where all data pertaining to drawings is populated. There are four additional sheets that contain data pulled from the master sheet. The project is to automate the data population of the sheets: "Drawing Checkout Tracking" "IFA Submission" "IFC Submission" "As-Built Submission" Use the data already populated in the sheets to understand what the requirements are. Requirements: 1. All data must automatically populate using a macro or some other automated process. If needed, you can put in a "button" that retreives the data on each sheet so the automation process happens only when desired. 2. The print formatting of the four sheets above must remain intact and be ready to print at any time To qualify: 1. Review the attached sheet and provide a description on how you intend to approach the problem 2. Provide me an example of your work, either by modifying the sheet provided or by showing me similar work you have done.
Project ID: 9607670

About the project

19 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
Hello, I think I am the perfect candidate for working on this project. I am proficient in Excel and VBA and macros and I would love to show you example of my work. Please contact me for more details.
$121 USD in 3 days
4.9 (137 reviews)
5.8
5.8
19 freelancers are bidding on average $104 USD for this job
User Avatar
Hi! Do you use one file for one project ? Please send me chat so that I can attach sample file. .
$150 USD in 3 days
5.0 (353 reviews)
7.4
7.4
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).
$140 USD in 7 days
4.9 (204 reviews)
7.3
7.3
User Avatar
Dear Sir/Madam, I'm happy to help you on this task. I am an expert in advanced excel features and have already developed such dynamic reporting tools for various business. If you are comfortable with my ratings and reputations, please send me the information to confirm. I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards, Priyal
$250 USD in 3 days
5.0 (186 reviews)
6.7
6.7
User Avatar
Hi A warm greetings! Thank you for the opportunity to submit a proposal in your job post. Please give me more details so that i could understand the project specification very well. I always work with perfection, fast and on budget. Waiting for your reply! Regards
$155 USD in 3 days
4.8 (137 reviews)
6.5
6.5
User Avatar
Hello, I am Excel and VBA expert. I can complete this project. I want to write a macro (VBA). I have done many similar projects - retrieve data from one sheet to another in an automatic way. Here are some examples: https://www.freelancer.pl/projects/project-9575884/ https://www.freelancer.pl/projects/php/Excel-Macro-9120719/ https://www.freelancer.pl/projects/Software-Architecture/Excel-VBA-Script-that-Compares/ https://www.freelancer.pl/projects/Excel/Excel-sheet-needed-based-two/ Please note that I have 100% completion rate and 5-star feedback on projects.
$100 USD in 3 days
5.0 (95 reviews)
6.0
6.0
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 65 projects, almost 60+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, 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.
$54 USD in 3 days
4.8 (75 reviews)
5.9
5.9
User Avatar
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. I can start working on the project immediately and complete the job within some hours. If you open a chat I cand send you a working mockup of your required spreadsheet immediately. Regards
$45 USD in 1 day
4.9 (62 reviews)
5.7
5.7
User Avatar
Hi, I am a professional in EXCEL and VBA and VB.net programming so I can help you with this project in minimal time. as I have worked on similar projects many times. what i am thinking of is a simple VB..NET tool that will handle all this process, as this will be much faster and flexible more than VBA note: check my first project https://www.freelancer.com/projects/User-Interface-IA/Program-Interface/ Regards.
$150 USD in 1 day
5.0 (30 reviews)
5.4
5.4
User Avatar
Hello sir, I go through your project description and found it simply doable. I have understood exactly what you want. I have been working on this type of projects from last few years. I have a team of 15 operators with me, who are very much efficient in MS Excel, copy paste, web extracting and various other data entry works. My team members are fast and accurate. We also do a quality check before sending the work to our clients. We promise to work with complete honesty, dedication and devotion. We are well known for on time delivery and accuracy. We are in the position of starting the work immediately, as we have a team. We can discuss more through PM. We are available on skype, hangout, and other messaging sites also. We are ready to send a sample of the prescribed work, before being hired. We assure of 100% accuracy. Hope to hear positive from you Thanks & Regards, Joy C TechnoVin India
$44 USD in 3 days
5.0 (6 reviews)
2.3
2.3
User Avatar
We at LumiNysis are the expert in MS Excel, VBA and automation across industries and are able to covert any data into useful results
$35 USD in 2 days
5.0 (2 reviews)
1.9
1.9
User Avatar
Hi Kevin here, I hope you will consider our team for your project. We will assure you a quality end product at a competitive price. I know you will be swamped with bids so thank you for the time. Hoping to hear from you soon and if you have any queries please do not hesitate to message us and we can talk. thanks
$144 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm an expert on MS Excel. I offer to write a code, which first of all will check whether new rows have been added to the master sheet. Is so, then for eache sheet an array wiil be created, which will contain the info from the master sheet according to the columns of each sheet to fil in. And, of course, the sheets with the criteria in columns Q,R,S from the master sheet will be filled in only it the condition is met.
$70 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$45 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Irvine, United States
5.0
42
Payment method verified
Member since Sep 12, 2011

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.