Compare 2 Excel Work Sheets, place difference on a third worksheet

Fertiggestellt Veröffentlicht Jul 19, 2013 Bezahlt bei Lieferung
Fertiggestellt Bezahlt bei Lieferung

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.

Datenerfassung Datenverarbeitung Excel

Projekt-ID: #4742944

Über das Projekt

25 Vorschläge Remote Projekt Aktiv Jul 21, 2013

Vergeben an:

nikitasvw

VBA expert

$25 USD in 2 Tagen
(16 Bewertungen)
3.3

25 Freelancer bieten im Durchschnitt $26 für diesen Job

zExcel

Hi, I will be happy to help with this right away if you can issue the order within an hour from now

$25 USD in 3 Tagen
(257 Bewertungen)
7.7
mrbrave

Excel expert here.....lets do it now...

$24 USD in 1 Tag
(304 Bewertungen)
7.0
maverick44000

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

$30 USD in 2 Tagen
(72 Bewertungen)
6.9
SiroosJafary

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.

$25 USD in 1 Tag
(71 Bewertungen)
6.0
sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$30 USD in 3 Tagen
(102 Bewertungen)
6.2
nagybatonyi

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

$30 USD in 3 Tagen
(64 Bewertungen)
5.7
riskypathak

How much you are comfortable if i create a c# application forthis task?

$30 USD in 1 Tag
(13 Bewertungen)
5.3
drevak

Dear friend, I can do this job because I have a great deal of experience in this area. Over 3 years of experience in Excel VBA will definitely come in handy. Could you check my portfolio for samples? I know the insight Mehr

$24 USD in 3 Tagen
(14 Bewertungen)
5.0
kamaljeetdd

Hi, ={{{Quality Assurance and Client Satisfaction}}}= Ready to Start now.... Thanks & Regards, Kamal

$30 USD in 1 Tag
(29 Bewertungen)
4.6
microk

Expert Here. Please check PM.

$30 USD in 3 Tagen
(31 Bewertungen)
4.4
thanhhungqb

Dear sir, please see pmb for details, thanks.

$20 USD in 3 Tagen
(17 Bewertungen)
3.9
Thang93

Hi dman902! I've done the job for you. Please check PM :)

$30 USD in 1 Tag
(12 Bewertungen)
4.0
mahfuzmurshed

I wish I am not too late! Please see PMB.

$25 USD in 3 Tagen
(36 Bewertungen)
4.0
dforce101

Hi, I am highly qualified for such task and I am eager to start. Please check your Inbox. Thank you

$30 USD in 1 Tag
(1 Bewertung)
3.4
rbbahia

Hi, I have large experience Excel and VBA macros. I can do it for you. Wait for your contact.

$24 USD in 3 Tagen
(12 Bewertungen)
3.5
chbelt7

I am interested in your project. I did many similar work, not as freelancer but there's a start in everything.

$30 USD in 3 Tagen
(2 Bewertungen)
1.2
sibeng

No Problem

$25 USD in 3 Tagen
(0 Bewertungen)
0.0
krishnadubey

Happy to complete it.

$35 USD in 1 Tag
(0 Bewertungen)
0.0
KassandraBH

I have the experienced needed for this project.

$25 USD in 3 Tagen
(0 Bewertungen)
0.0
saramine

I can do what you want.

$25 USD in 3 Tagen
(0 Bewertungen)
0.0