Find Jobs
Hire Freelancers

Excel VBA - compare specific data from multiple

$25-50 USD / hour

Completed
Posted over 5 years ago

$25-50 USD / hour

Construction business and we use Excel to create estimates. When creating estimate for complex projects we often create multiple tabs on same worksheet (create copy of original) to mock up different options for customer. Would like to use VBA to create a 'Comparison' tab which shows the highlighted cells (yellow) for each of the tabs on file. I have attached a very small mockup of actual file
Project ID: 17847438

About the project

33 proposals
Remote project
Active 6 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 am Bob and I'm ready to implement the needed comparison tab. Do you mean that only the yellow cells would be displayed on the comparison sheet or they contain the comparison criteria? Why there are repeating values in the 'General Information' column? Is it because this is a mockup? Are you looking to optimize the worksheet structure or you want the macro to work on that exact structure? I can give you some tips about the workflow and the overall layout of the table... Ping me to discuss the details and give you a more accurate estimation of the job length and cost. Thank you for considering my application!
$39 USD in 40 days
5.0 (2 reviews)
5.4
5.4
33 freelancers are bidding on average $34 USD/hour for this job
User Avatar
Hello, I have the good knowledge of Excel VBA - compare specific data from multiple. I have more than 5 years of experience in Excel, Visual Basic, Visual Basic for Apps . I have reviewed your job and can deliver you the job with 100% satisfaction. Please ping me for more discussion.
$30 USD in 40 days
4.9 (393 reviews)
8.1
8.1
User Avatar
Hello! My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects are among the tasks I work with regularly and know exactly how to handle them. You mention that you need somebody to develop the VBA code that will automate the process of filling a Comparison sheet which will have highlighted cells. I'm going to spend less than 2-3 days to complete your project including required revisions for a payment of $40/hour . I never ask for any payment in front. I claim the milestone release once the project is completed and my client is happy with the result. I'm a very experienced and skilled MS Office developer as you can easily check for yourself. You're welcome to visit my personal page on this platform and get an idea of who I am and what services I deliver to my clients. I'm looking forward to hearing from you. Sincerely, Paris Pallas
$40 USD in 40 days
4.9 (309 reviews)
7.8
7.8
User Avatar
Hi there,I am Miljan,Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$29 USD in 40 days
4.9 (140 reviews)
7.5
7.5
User Avatar
Hello there, This looks feasible and I can do this quickly. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Thanks A
$25 USD in 10 days
4.9 (176 reviews)
6.5
6.5
User Avatar
Hello Sir, Thanks for the requirements, I can do perform following activities : 1) Date Separation using Excel related functions, ( VLookUp, HLookUp, Conditional Formatting, Text To Column, If etc) 2) Excel VBA Macro Creation 3) Text Pad Macros creation by Regular Expression 4) Manage Excel into proper format. 5) Concatenate data with other tagging excel sheet. 6) Convert Excel data into XML using different macros 7) Checking Data Conversion 8) Check each and every tag by Epsilon tool and publishing tool 9) Web based data collection ( Mazilla and Chome Add-on ) 10) Strong Web research Please message me so we will have some productive discussion on the same. Thank You
$41 USD in 40 days
5.0 (13 reviews)
6.2
6.2
User Avatar
I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to develop highly dynamic and automated dashboards and templates for data analysis, data automation, financial modeling and various other computations, analysis and automation. I will be happy to discuss in detail that how I am highly suitable for this project.
$25 USD in 3 days
4.7 (99 reviews)
6.1
6.1
User Avatar
Hello there, as an expert in excel and VBA, i can help you to accurately compare and highlight your data as you have specified. Please contact me and let us talk more about your project. Thanks
$25 USD in 10 days
5.0 (83 reviews)
5.8
5.8
User Avatar
Hello Sir, I read your project description and I am very interested in it I need some more information Can we discuss the project I am waiting your response thank you
$41 USD in 40 days
4.8 (31 reviews)
5.5
5.5
User Avatar
Hello, This will be a quick job as mentioned in the project description. I can deliver this by tomorrow. Let's discuss over chat. Thanks, Rayyan
$41 USD in 40 days
5.0 (18 reviews)
4.9
4.9
User Avatar
Hi Sir, This is Gopal. I am an accountant. I have gone through your project description and I am able to do it. I would like to draw your kind attention on few of my excel skills:- Maintaining and organizing data, Data Management, Data Entry. VBA,Formula development, VLOOKUP, HLOOKUP, LOOKUP, IF, INDEX, SUM. Pivot Table Development and Management Process Improvement Develop and implemented standard operating procedures to bridge data gaps and resolve related issues. Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions. Designed, recorded, and executed macros to automate data entry inputs. Formatted spreadsheets and workbooks for print, document reproduction, and presentations. Kindly note that I have been working in Accounting, Tax, Audit and Finance function for more than 5 years. Hence, I have expertise on SAP, Tally ERP9, Quick Books, MYOB, ZOHOBOOKS, XERO, MS Access, MS Word, PowerPoint and MS Excel. Recording daily transaction or Book-keeping, Maintaining Books of Accounts, Reconciliation and finalisation of accounts are major areas of my job profile. Hence, I request you to grant me an opportunity to serve you by executing and finishing the project giving my level best and so that I could establish myself on this platform though I am new at freelancer. Looking forward for your positive response. Thanks
$40 USD in 40 days
5.0 (15 reviews)
4.7
4.7
User Avatar
Hello I would be able to help with your comparison macro. My name is Steve, I have worked with excel/vba for over 10 years for a global financial services company. In that time I became the local lead for all excel/vba based issues which lead me to design and implement many complex spreadsheets and macros. This helped to gain efficiencies in our daily tasks and increase our profitability and I’m sure this experience will be of use to you with your project. I hope to hear back from you soon. Kind regards Steve
$33 USD in 5 days
5.0 (8 reviews)
4.0
4.0
User Avatar
Hello, my name is Esteban, I'm an industrial engineer. I would like to help you in your project and hope you help me earn my first points!
$25 USD in 40 days
4.9 (27 reviews)
4.3
4.3
User Avatar
Hi, I have extensive experience of developing Excel VBA macros for the purpose of automating dashboards and reports with overall experience of over 7 years in various MNCs. My passion is to provide quality and timely deliverable to client thus creating client ecstasy. I make it a point to adhere to tight deadlines and submit deliverable with 100% accuracy.
$25 USD in 40 days
5.0 (1 review)
2.1
2.1
User Avatar
Hello, I would like to take this opportunity to introduce myself. My name is Satish Chandra and I have held several senior level positions during my professional career spanning over 15+ years. I have around 5 years of experience handling 8 teams PAN India as a Senior Manager. Besides this, I am an expert in Visual Basic for Applications (VBA - Macros) for automating complex Excel based reports. I am also an expert in data visualization tools like Tableau. I also have developed a few applications in Android Studio for Android platform which involves writing code in native Java and XML. I have also successfully completed the course in PMP from Simplilearn earning 35 Personal Development Units (PDUs). I have keen interest in Six Sigma, TQM and management methodologies like PDCA, Herzberg's X and Y theory, McGregor's Hygiene theory and am a protagonist of Kanban, Kaizen and Continuous Improvement. Thanks & Regards Satish Chandra +91-9999986050
$27 USD in 40 days
4.8 (2 reviews)
1.6
1.6
User Avatar
Hello, I am quite interested in your job. Let me explain my experience. Over 6 years of experience in Management Information System (MIS) with excellent skills to create dashboards, reports and automate it using scripts. I had good exposure in tools for data analytics, data visualisation, gap analysis and process mapping. Ability to think “out of the box” and propose alternatives to solve problems and have a flexible approach to change and able to work effectively in a variety of situations. Currently based in Johannesburg, South Africa. Expert in Tools:- -Microsoft Excel/Macro/Advance Formula. -Microsoft Power BI. -Microsoft Word. -SQL. If you have any questions about my work, please do not hesitate to ask. Regards Shyamapada Singha
$27 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
This project is right up my alley! I have 30+ years in the construction industry and have created many similar databases/spreadsheets for construction projects I am very proficient with excel and I know I can give you exactly what you need. I provide you with constant updates and request/implement your feedback in a timely manner. I am available from 6 am to 8 pm Eastern US time to answer any questions.
$44 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am a finance professional and I live and breathe spreadsheets and VBA. Based on the info provided I should be able to complete the project within 5-10 hours.
$44 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 7+ Years of experience in designing Excel dashboards, templates and VBA Macros. I have designed many projects to communicate with other applications like power point, Access, Internet Explorer and mainframe applications
$41 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would happy to assist you in all type of designing task with 100% job satisfaction. hey there, I can do the data entry well, I also have the experience, I have some special skills which are as follows, data entry Logo designer Microsoft Office Ms word Ms excel Ms powerpoint photoshop image editing Page maker Content Writing Translation (Hindi and English) photo editing video editing typing data transcription, etc.. i will do this work in minimum time and good accuracy.. please hire me and give a chance to work with you. Thanks & Regards Sourabh Kourav
$50 USD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Cedar Rapids, United States
5.0
2
Payment method verified
Member since Sep 26, 2018

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.