Find Jobs
Hire Freelancers

Cross Reference Check in Excel

$30-250 CAD

Completed
Posted over 7 years ago

$30-250 CAD

Paid on delivery
I'm looking to match the information on the control sheet, "Invoice Tracking" tab, to the time sheets in the other tabs on the work sheet. If the Invoice number on the time sheet has a check mark in the adjacent cell, I'd like to have a check mark in an adjacent cell in the control sheet. This is something that will have to run daily to ensure all the invoices have been returned to the office
Project ID: 11518678

About the project

25 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
This is EASY....I can do this in few hours and will send you the sheet. I am top excel developer on this site. Check my past reviews to verify my credentials. Looking for your reply.
$100 CAD in 0 day
4.9 (326 reviews)
7.6
7.6
25 freelancers are bidding on average $98 CAD for this job
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$100 CAD in 1 day
4.9 (401 reviews)
7.6
7.6
User Avatar
Hi, I am an Excel automation expert and would be happy to assist you. Shall deliver a solution to automatically check and place a check mark under matched rows. Regards, Arul
$150 CAD in 1 day
5.0 (173 reviews)
7.4
7.4
User Avatar
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
$210 CAD in 3 days
4.8 (297 reviews)
7.1
7.1
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$80 CAD in 0 day
5.0 (271 reviews)
7.1
7.1
User Avatar
Hi, I have 3 years of experience in Excel VBA programming. For the requirements I would propose two solutions: 1. A button for the Invoice Tracking sheet. When pressed it matches the sheet of each employee with the Invoice Tracking sheet and insert the checkmark if necessary. 2. Another one would be a macro that automatically gets triggered if there is any change next to a invoice number cell on any employee sheet. Which one do you prefer?
$125 CAD in 2 days
5.0 (121 reviews)
7.0
7.0
User Avatar
Hey there. Checked your file. It seems terrible :)) Ok, lets write your code to automatize the workflow ass you described. We can also improve the formatting a bit. Contact me. Regards..
$250 CAD in 3 days
5.0 (141 reviews)
7.1
7.1
User Avatar
Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. I can get your work completed within a day. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
$30 CAD in 1 day
5.0 (209 reviews)
6.9
6.9
User Avatar
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to do your project. Please contact me to discuss the details. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$100 CAD in 1 day
4.8 (172 reviews)
7.1
7.1
User Avatar
Hi, I have read the project and understand your requirement. I am a highly trained on Data Analysis, Research and Expert with great knowledge of Excel. I have experience to do this types of statistical measurement job using different VBA macros. I also generated Yahoo Finance automated template updating all the stock data.
$74 CAD in 3 days
4.9 (144 reviews)
6.4
6.4
User Avatar
I am an ACCA (UK) professional , APA and Mcom finance. After carefully reading your project description, I think that I am the perfect candidate! With over 8 years of experience in advanced use of MS Excel, I can guarantee getting the job right the first time. Feel free to view my 100% positive reviews before you hire me and rest assured that you will receive top-quality work at an affordable cost. Kind regards, Javed
$147 CAD in 3 days
4.9 (100 reviews)
6.5
6.5
User Avatar
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 280 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$100 CAD in 5 days
4.9 (115 reviews)
6.2
6.2
User Avatar
This is super easy. I can show you sample right away. I can do it in just 24 hours. You can check my past reviews(all 5 stars)
$30 CAD in 1 day
5.0 (21 reviews)
5.4
5.4
User Avatar
HI I am an excel-vba expert and I can help you with your project start the chat to discuss more ..........................................................................................
$111 CAD in 5 days
5.0 (37 reviews)
5.3
5.3
User Avatar
Greetings, I have completed the task by using a VBA macro. After clicking a button "Verify completion" in Invoice Tracking sheet, check marks appear. Operation took 3 seconds on my PC. Here is what the macro does: - all visible sheets are checked for occurance of "INV #", invoice numbers are numeric values taken from a column in which "INV #" appears, check mark is taken from 4th column to the right of invoice numbers column - if invoice number has a check mark, then if such number in Invoice Tracking exists, it receives a check mark INV # is sometimes in column F, sometimes in column G - that's why I constructed macro like this. Some numeric values in INV # column are not invoice numbers, but it doesn't hurt, there are max 3 figures, Invoice numbers are 5 figures, besides they aren't going to have a check mark.
$30 CAD in 1 day
5.0 (60 reviews)
5.3
5.3
User Avatar
Hello I'm a software developer with a lot of Excel automation experience and can do this job in 3 hours. Please contact me if interested. Best regards, Dennis Poduzov
$77 CAD in 1 day
5.0 (22 reviews)
4.8
4.8
User Avatar
Dear Sir, I am interested in your project. If I well understand you need simply that the sheet can recognize the mark automatically, without checking manually every time. So, my bid covers your need. However, lokking at your sheet and imagining your needs, you could consider to use a small dedicated software. Its price could be different, according to the implemented functionalities, but I think that 300-500 CAD coul be solve your needs. In any case, I confirmby bid for the excel problem. Please contact me if you want to share with me some further details. Best Regards, Marzio
$55 CAD in 3 days
4.8 (8 reviews)
4.1
4.1
User Avatar
Hello. Understand, how to do this job. Skills in VBA, experiance of working in word, excel, access. No problem with this job and those tasks from discription.
$40 CAD in 5 days
4.2 (5 reviews)
2.8
2.8
User Avatar
Hello Sir, About Me ------------------------- I am an experienced Developer from Sri Lanka with bachelor’s degree in computer science. currently working as, a SAP developer. In my free times I am doing part time administrative related tasks. I have more than 7 years’ computer experiences. About the Task ------------------------ I read instructions and understood what need to be done. I have done several this kind of data manipulation tasks. Below are few of them - Create excel template for a stock management consultancy group which manipulate data to use daily - Retrieve data from different sources (different Excel workbooks, worksheets, ERP systems) - Send data to another system (different Excel workbooks, worksheets, ERP systems) - Macro creations for data clearings - Summary Generations - Generate Financial reports I'll try my best to complete this ASAP with required quality. I am looking forward to work with you. Thanks & Regard, Hasini
$45 CAD in 3 days
5.0 (2 reviews)
1.5
1.5
User Avatar
Dear Sir/Madam, I would be glad to help you with this project. I will do my best to meet your expectations. Best regards, Jana V.
$55 CAD in 2 days
5.0 (1 review)
1.0
1.0

About the client

Flag of CANADA
Parksville, Canada
5.0
1
Payment method verified
Member since Sep 13, 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.