Find Jobs
Hire Freelancers

Excel VBA Script - Highlight changes from list

$10-30 USD

Completed
Posted over 4 years ago

$10-30 USD

Paid on delivery
I have a file that has a tab of about 200,000 observations or more. This tab (called "HIGHLIGHT") in the attached tells me if SOMETHING was changed in the subsequent tabs. Column1= tab name and the other 4 columns = variables found in the SECOND row. The VBA is supposed to look for the desired tab under "form name", and look at the second row in the desired tab for those variables mentioned in the first tab, by looking for those 4 variables mentioned in the first tab's list, and then highlighting the cell that it finds, preferrably a yellow color. Data processing must be efficient as 200,000 observations or more may be found in the first tab.
Project ID: 22853729

About the project

11 proposals
Remote project
Active 4 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 have understand the project requirement & interested to work for this project. Please send a message so we can discuss more & start the project. Thanks.
$20 USD in 1 day
5.0 (143 reviews)
6.0
6.0
11 freelancers are bidding on average $25 USD for this job
User Avatar
Hi, Are there 4 variables or 6 variables, I mean for a given form (say form1, form2, form3 or form4) it appears that there are 6 variables i.e. (Site, ID, Age, Gender, Height and Weight) and not 4 as mentioned in project description. Kindly clarify. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have done good amount of work in VBA. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc. I have also handled various Excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 10 years of experience to my credit. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks
$30 USD in 2 days
4.9 (98 reviews)
6.0
6.0
User Avatar
$15.00 Only ----- In just 1 Hour ----- Excel VBA Macro Coding, Formula Generation and Automation Expert with 5* ratting.
$15 USD in 1 day
5.0 (95 reviews)
5.2
5.2
User Avatar
Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Server, MySQL, SQLite, PostgreSQL, Firebird Write Automation apps including: * Automation Desktop apps. Some examples: Automation Playing Games, Automation Start/Stop/Click 3rd party apps * Automation Web apps. Some examples: Automation Web Scraping apps, Automation Web Crawling apps * Automation Data Processing apps: Automation formatting data to a specified template * Automation Data, Document Converting apps * Automation Macro, VBA for all apps in MS Office (Excel, Word, Outlook), OpenOffice, GoogleSheet * Automation Installers/Setups * Convert your Manual tasks to Automation solutions Write Web Service, Web API, Desktop API apps. Some examples: Google API, Bing API, Facebook API, MS API Fix/Solve any errors in your OS, apps
$15 USD in 1 day
4.8 (33 reviews)
5.0
5.0
User Avatar
Hi, I can write a VBA that can easily find each instances for tab 1 data in other tabs, However, I didn't catch what you need to do after the data has been find? You want to update the data of tab "Highlighted" or something else want to be done? please send me message to discuss more
$50 USD in 1 day
5.0 (12 reviews)
4.5
4.5
User Avatar
Hi Sir, I'm expert in using excel.. I have done a lot of projects like this one before. you can check my page and i'm sure that you will satisfied with the output.
$20 USD in 7 days
4.8 (27 reviews)
4.5
4.5
User Avatar
Hi sir, I am willing to do your task. I have experience in this and have been doing this for a long time. I’m very much confident that I can do this task as you want it. I have expertize in Data entry, Copy-Paste, Microsoft Excel, Microsoft Word, Power Point and Invoice. You can let me do your task, if you want. I can ensure you that I will do your task perfectly and satisfy you. Kindly send me message if you want to give me the project. Have a good day, sir.
$35 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir, Hope you are well. I have completely read your all information. I understood with your all statements. I have two years experience of data processing, data entry, I worked in an organization as a data processing worker. So, if you want any prove i will show you about my previous project details. If you agree you can hire me. i am waiting for your reply. Thank you
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
WARREN, United States
5.0
11
Payment method verified
Member since Mar 2, 2014

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.