Find Jobs
Hire Freelancers

Comparison of excel files

$30-250 USD

完了済み
投稿日: 10年以上前

$30-250 USD

完了時にお支払い
I have three different excel sheets containing similar data that I need to compare to find the differences. I believe a VB script would make the most sense but am open to other solutions to be the most efficient. The sheets can be in individual excel files or as different tabs in the same file whatever makes the most sense. Collection List – 9-30-2013 – This sheet is the authoritative data set. cci export – this needs to be compared to the above sheet as it changes frequently. Cci account import – This was an initial list of accounts that was provided to build what became the data in the cci export sheet. The unique cells to compare are - “Client Reference Number” - “Agency” Meaning you will need to look compare the two sheets as follows: - Ensure that should the “Agency” field contain the string “CCI” and it should exist in the “cci export” sheet. - Should show anything that the “Export” field is set to Y and is not in the CCI export sheet as an exception. - Should flag in a new column with the intention of showing what was in the “CCI account import” sheet and that didn’t make it to the cci export data. Any exceptions I would like to be flagged or highlighted in some fashion that I can sort and then correct in the “Collection List” sheet. Example a new column can be added called “Exception” with a Y for example. Additionally I will need to have a way to exclude rows, logically a new column added called “Exclude” that would be ignored for future runs of the macro or script. Likewise the exception column would need to be cleared at the beginning of each run so I can correct discrepancies. I have provided a small subset of the data and can provide the actual data to the winning bidder. The data size is as follows: Collection List – 9-30-2013 – 1971 rows Cci export = 390 rows. Cci import = 1618 rows Though the sample I have provided obviously is much shorter. The data evolves with the cci export list growing frequently. My goal is to have some way to make this semi-automatic to see changes to the cci export list as they happen. Meaning I will run this macro or whatever it is roughly every couple weeks to flag the exceptions.
プロジェクト ID: 4981942

プロジェクトについて

31個の提案
リモートプロジェクト
アクティブ 10年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
Expert Here. Please check PM..
$45 USD 3日以内
4.9 (27 レビュー)
4.3
4.3
この仕事に31人のフリーランサーが、平均$124 USDで入札しています
ユーザーアバター
Excel VBA Expert. Please check PM for details. Thanks.
$55 USD 3日以内
5.0 (600 レビュー)
8.3
8.3
ユーザーアバター
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply. I can start with the implementation immediately.
$147 USD 2日以内
4.9 (325 レビュー)
7.6
7.6
ユーザーアバター
Hi; your 5-star excel and vba coding expert is ready to help you... kindly check your PM and get back to me if you wish to proceed with a top-rated and reliable partner here....regards,
$110 USD 3日以内
4.9 (259 レビュー)
7.6
7.6
ユーザーアバター
Hi, I can take on the job. Please confirm.
$100 USD 1日以内
5.0 (183 レビュー)
7.3
7.3
ユーザーアバター
Dear Sir I'm happy to help you on this task..Please check PM. thanks- Priyal
$90 USD 3日以内
5.0 (179 レビュー)
6.7
6.7
ユーザーアバター
Hi Palin. Being highly proficient in VB and Excel, I can write a new VB macro for you that does the work. Lets begin and get started on it. I have solved many similar sheets before and I can do one for you too. Regards
$150 USD 2日以内
5.0 (68 レビュー)
6.7
6.7
ユーザーアバター
Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. Here are the links for my past experiences: https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html https://www.freelancer.com/projects/4848189.html https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html Regards.
$83 USD 3日以内
5.0 (70 レビュー)
6.0
6.0
ユーザーアバター
I will give u simple application which will tkae the excel sheets as input and give u output as u described in project solution. Please see sample applications in your PMB
$100 USD 1日以内
4.9 (33 レビュー)
5.6
5.6
ユーザーアバター
I am very proficient in dealing with word, ppt, access, excel files, and good at VBA programming, I have exceed 6 years of VBA programming experience now. Please trust me, and let expert do it.
$50 USD 1日以内
4.9 (18 レビュー)
5.6
5.6
ユーザーアバター
Hey dpalin, we have an experts team with plenty of years in Excel VBA.. Yes, you are right - VB script can be used to achieve the comparison.. please reply.. thanks
$77 USD 3日以内
4.8 (145 レビュー)
5.8
5.8
ユーザーアバター
Such jobs are my daily practice. Regards
$111 USD 2日以内
4.9 (62 レビュー)
5.7
5.7
ユーザーアバター
Hello. I'm an engineering student that has high Excel and Visual Basic skills with great professionalism. Check PM please.
$49 USD 3日以内
5.0 (59 レビュー)
5.4
5.4
ユーザーアバター
Expert of Excel,Ready to start.
$90 USD 3日以内
4.9 (42 レビュー)
4.9
4.9
ユーザーアバター
Hi, Ready to start your work. Eagerly awaiting for your positive reply. Please check your inbox for further details. Thanks, Shaik.
$155 USD 3日以内
5.0 (25 レビュー)
4.6
4.6
ユーザーアバター
Good Day!... I'm an Expert in Excel Automation. Very Imp: Pls check my Private message to you.
$150 USD 0日以内
4.7 (21 レビュー)
4.4
4.4
ユーザーアバター
hello, i can do this for you
$105 USD 3日以内
5.0 (17 レビュー)
4.2
4.2
ユーザーアバター
I have already worked for you and I can complete this within a day. I will create a simple .net form application to compare the excel sheets. From the understanding I got, we need to compare the collection list with the export list. Where should the output be captured, i mean the additional columns, in the collection list itself? Please let me know and I can start right away
$155 USD 3日以内
5.0 (10 レビュー)
3.6
3.6
ユーザーアバター
Dear Sir, give me a chance for this job. Thank You
$155 USD 10日以内
5.0 (1 レビュー)
2.8
2.8
ユーザーアバター
Ready to start
$210 USD 3日以内
5.0 (1 レビュー)
1.6
1.6
ユーザーアバター
Hi, I would like to take this opportunity to work with you . Please consider my bid.
$111 USD 3日以内
5.0 (1 レビュー)
1.3
1.3

クライアントについて

UNITED STATESのフラグ
Vancouver, United States
5.0
77
お支払い方法確認済み
メンバー登録日:11月 11, 2003

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。