Excel VBA - compare specific data from multiple

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

Skills: Excel, Visual Basic, Visual Basic for Apps

See more: vba compare data in 2 spreadsheets, macro to compare two excel sheets cell by cell, how to write a macro to compare two excel sheets, excel vba compare two tables for differences, how to compare two columns in two different excel sheets using macro, vba code to compare two excel sheets and highlight differences, excel vba compare two columns different worksheets, compare two worksheets and paste differences to another sheet - excel vba, excel, microsoft, microsoft office, microsoft access, visual basic for apps

About the Employer:
( 2 reviews ) Cedar Rapids, United States

Project ID: #17847438

Awarded to:


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 repeati More

$39 USD / hour
(2 Reviews)

36 freelancers are bidding on average $34/hour for this job


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community ( More

$40 USD / hour
(664 Reviews)

I am ready to write VBA code to create a Comparison tab which will show the highlighted cells (yellow) for each of the tabs on file. I checked sample attached file. I need to discuss in detail before starting and need More

$47 USD / hour
(205 Reviews)

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 y More

$30 USD / hour
(290 Reviews)
$40 USD / hour
(219 Reviews)

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 More

$40 USD / hour
(179 Reviews)
$25 USD / hour
(283 Reviews)

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 th More

$29 USD / hour
(88 Reviews)

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. P More

$25 USD / hour
(172 Reviews)

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 / hour
(80 Reviews)

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 / hour
(31 Reviews)

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 M More

$41 USD / hour
(12 Reviews)

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, More

$25 USD / hour
(42 Reviews)

I am an Excel specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$25 USD / hour
(64 Reviews)

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 / hour
(15 Reviews)
$41 USD / hour
(3 Reviews)

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/v More

$33 USD / hour
(5 Reviews)

-Professional Excel, Visual Basic, Visual Basic for Apps expert ! Best Result in Time!-- Hello sir. I've really rich experience for your project, so your project is very interesting to me. I'm really confident about More

$25 USD / hour
(1 Review)

Hello nice to meet u I have good skills about vba If u want me, I can my previous work I can do your work perfectly I think that your job is good for me I m attractive for your project thank u from artemova

$41 USD / hour
(3 Reviews)

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 / hour
(7 Reviews)

--Very Nice Job. Professional Excel, Visual Basic, Visual Basic for Apps expert. Best result in time----- [login to view URL] I read your description very carefully. I am very interesting for your project because I have ric More

$50 USD / hour
(2 Reviews)