Find Jobs
Hire Freelancers

Excel VBA macro for comparing worksheets row by row

$10-30 USD

Inaendelea
Imechapishwa almost 6 years ago

$10-30 USD

Kulipwa wakati wa kufikishwa
1 Develop an Excel macro in this Excel workbook that compares the values between Sheet1 and Sheet2 2 Compare just the first column in Sheet1 to the first column in Sheet2 3 Create a new worksheet named Compare Result that shows the result of the comparison 4 If the Compare Result worksheet already exists then delete and create a new worksheet named Compare Result 5 The Compare Result worksheet will be a merge of Sheet1 and Sheet2, inserting rows that exist in one sheet but not in the other. 6 You have to assume that there may be gaps and missing rows in either Sheet1 or Sheet2 7 You can assume that the rows Sheet1 and Sheet2 will be sorted in ascending order by value 8 In Compare Result list the Row number from each sheet to indicate where the row value comes from 9 If the values are equal they should be shown on the same row in the Compare Result worksheet 10 If the values are not equal you should insert a new row in the Compare Result sheet using the color coding to indicate an unequal comparison. 11 You may need to read-ahead to get the Compare Result back in sync after an unequal comparison 12 You can assume the row limit in either sheet is < 10,000 rows 13 The result should look something like the example given in the Compare Result sheet 14 VBA code must be well documented with comments and be self-contained; it cannot branch out or call any proprietary subroutines or any code not included in the delivered Excel XLSM. 15 Freelancer Employer reserves the right to use, modify or enhance the VBA macro code in any manner. 16 The Freelance Developer who developes this Excel VBA macro relinquishes all rights to the legal ownership or reuse of the VBA macro code.
Kitambulisho cha mradi: 16746291

Kuhusu mradi

20 mapendekezo
Mradi wa mbali
Inatumika 6 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
20 wafanyakazi huru wana zabuni kwa wastani $34 USD kwa kazi hii
Picha ya Mtumiaji
Hi, Your description explains all the requirements pretty well. (You wouldn't think how scarce these descriptions are) I have one questions only. Since your source files won't contains these macros and I guess you will have to manually copy-paste the content of sheet 1 and 2 from other files, I can propose you an extra button that opens the file dialog, you select the source file, and the content of the selected file will be pasted into the macro file. Maybe it doesn't save a lot of time but if you like it, I can do it (included in the proposed price) Regards, Balint Kolosi
$100 USD ndani ya siku 1
5.0 (135 hakiki)
7.1
7.1
Picha ya Mtumiaji
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. Best regards
$50 USD ndani ya siku 3
5.0 (314 hakiki)
7.4
7.4
Picha ya Mtumiaji
Hello Sir, I understood this project. I am very interested in the work. Please sir i am want discuss your project. I am waiting for replay. Thank you. Suvash
$23 USD ndani ya siku 1
5.0 (44 hakiki)
5.5
5.5
Picha ya Mtumiaji
Hello sir, I am interedted in your project. I would like to discuss details via pm. Yours sincerely,
$10 USD ndani ya siku 1
5.0 (31 hakiki)
5.5
5.5
Picha ya Mtumiaji
I have reviewed the file (and started writing out some test code) and task and this is definitely achievable using a series of loops iterating until you reach the count of the used rows in the sheet. There obviously need to be several sub-loops as well to cover the places where the two sheets don't match each other (or alternatively a match formula could be used, however over a large dataset this can cause performance issues). As this is a non-trivial amount of work I have put in a bid which is over budget, however I still believe my bid represents excellent value. About me: I am a professional business analyst with over 15 years experience building automated data processing solutions with Excel and VBA. I have expert level technical skills, a strong attention to detail, and an excellent work ethic. I have built a number of similar solutions and would love the opportunity to work with you on this project!
$45 USD ndani ya siku 1
5.0 (33 hakiki)
5.5
5.5
Picha ya Mtumiaji
Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas and Macros using VB, the most important thing is that I can do the job, quickly and well done. Please, contact me and let's talk about how I could help for your project.
$25 USD ndani ya siku 2
5.0 (15 hakiki)
3.8
3.8
Picha ya Mtumiaji
..............................................................................................................
$66 USD ndani ya siku 2
4.9 (5 hakiki)
2.7
2.7
Picha ya Mtumiaji
i have done the same that i can show you. event when the row big it can run very fast by using high technique
$35 USD ndani ya siku 1
3.5 (4 hakiki)
2.1
2.1
Picha ya Mtumiaji
A proposal has not yet been provided
$15 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
A proposal has not yet been provided
$25 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
"Dear Next Employer We will give you the best result by using my Past experience and excellent academic skills on your project. You can chat with me and let's get started, I'm ready to show you samples of similar projects I've completed. Thanks
$55 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Dear sir, I am new freelancer but I am expert in Excel and VB for applications. I am sure I can do your task perfectly.
$25 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Works as a Database Management Virtual Assistant for a leading MNC, handling clients in the US & Canada. Supporting business, SME's by creating VBA, Access, and Excel databases. Looking to land a project to earn extra.
$25 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya UNITED STATES
Tempe, United States
4.3
3
Njia ya malipo imethibitishwa
Mwanachama tangu Feb 15, 2010

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.