Compare 2 Excel Work Sheets, place difference on a third worksheet
$10-30 USD
Paid on delivery
The goal of this project is to compare 2 worksheets and place the difference on a third worksheet.
1. There are 3 tabs; NET SUITE, CONDB, and VALIDATION
2. Use the values in Column A (CONDB and NET SUITE) to sort by
1. Get the value of [login to view URL]
2. Search NET [login to view URL] for the same name
1. If found, compare the lines
2. If not found, add the entire line to the VALIDATION worksheet (high light the line in Red background)
3. When doing the comparison, compare cell by cell
1. If all of the cells in the row are identical on both worksheets, do nothing. Proceed to the next line
2. If one or more of the cells do not match, add the incorrect line to the VALIDATION worksheet
1. Highlight the incorrect cell(s) in Yellow
2. Highlight the rest of the row in Red
4. Comment the source code showing me where I can make changes to add more columns to the comparison
5. I attached a spread sheet that I had created a while ago that did the same thing. I tried to modify it, but could not figure it out. Feel free to tweak the attached macro or you can create a new one.
6. I would like to keep the message boxes used in the attached spreadsheet.
7. I would like to add a status counter indicating that the comparison is in progress and it should display a completion percentage.
Project ID: #4742944
About the project
Awarded to:
25 freelancers are bidding on average $26 for this job
Hi, I will be happy to help with this right away if you can issue the order within an hour from now
Hi dman. Consider it done. Its a pretty simple task and I recently finished a very similar job for another client in US. I shall be glad to do one of yours too. Regards
Good day, consider it is done. I am expert in excel. I am teaching excel. I will teach you how to do it easy. Regards.
Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards
Such jobs are my daily practice. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
Hi, ={{{Quality Assurance and Client Satisfaction}}}= Ready to Start now.... Thanks & Regards, Kamal
Hi, I am highly qualified for such task and I am eager to start. Please check your Inbox. Thank you
Hi, I have large experience Excel and VBA macros. I can do it for you. Wait for your contact.
I am interested in your project. I did many similar work, not as freelancer but there's a start in everything.