Käynnissä

VBA code to compare 2 columns in excel or Access

I have 2 lists

List 1 has the following:

Samsung BL103

Samsung SCH A870

Samsung SCH A930

Samsung SCH A950

Samsung SCH I220 Code

Samsung SCH I760

Samsung SCH i770 Saga

Samsung SCH I910 Omnia

Samsung SCH I920 Omnia

Samsung SCH R311 Axle

Samsung SCH R350 FREEFORM

Samsung SCH R351 FREEFORM

Samsung SCH r355 FREEFORM

Samsung SCH R410

List 2 has the following:

Samsung BL103 stl

Samsung SCH-A870

Samsung SCH-A930

Samsung SCH-A950 dsa

Samsung Code SCH I220 dsd

Samsung SCH I760 ddd

Samsung Saga SCH i770 dfg

Samsung Omnia SCH I910

I need to compare those 2 lists and give me the items in list 1 NOT present in list 2 and the items in list 2 NOT present in list 1.

The item specific is the alphanumeric code (BL103) in the first item. If this alphanumeric value is the same in both lists, it means that there is no missing record.

I am almost sure this will be a vb code that i have to add to excel. I use excel 2010. Please provide some info on how to implement this.

I will pay an easy 15$ for this.

I will pay once this work in my excel sheet

Thanks

This is what is expected of the vba:

Take a cell, find the alphanumeric part in it (anything before the "-" is not part of the alphanumeric; SCH- for example is not part of the alphanumeric)

Compare the alphanumeric substring to list 2 and see if it is contained in the cell

Repeat that until list 1 is over, then do the same to list 2
Thanks

Taidot: Excel, Microsoft Access, Visual Basic

Näytä lisää: excel vba compare columns, compare columns access, compare columns excel access, vba code compare columns, excel compare list columns, vba code compare columns access 2010, compare columns excel vba code, vba code compare lists, access vba compare columns, excel vba compare lists add list, access 2010 vba compare columns, access compare columns, compare columns vba, vba compare columns, compare columns excel vba, code columns excel access, vba compare lists, vba compare access excel, excel vba code compare items columns, vba code compare lists excel, code compare excel access, compare list excel vba, code access compare columns, stl list, stl in c

Tietoa työnantajasta:
( 25 arvostelua ) Beirut, Canada

Projektin tunnus: #4274028

Myönnetty käyttäjälle:

Premshanks

Easy job . pl accept to complete it faster

$10 USD / tunti
(183 arvostelua)
6.0

4 freelanceria on tarjonnut keskimäärin 14 $/tunti tähän työhön

mrbrave

Lets do it now...

$15 USD / tunti
(69 arvostelua)
5.3
vladang

Hello sir. I can do this job. Regards vladang

$15 USD / tunti
(1 arvostelu)
1.4
yloubani

It just happened I did this one last week and its working fine. will be a matter of minutes actually.

$15 USD / tunti
(0 arvostelua)
0.0