Devam Ediyor

502037 Compare 2 lists and copy row

The environment as follows:

I have 2 workbooks - [url removed, login to view] and [url removed, login to view]

[url removed, login to view] has columns - Product Barcode, Product Description, Attributes1, Attributes2, Attributes3, Attributes4, Attributes5, Attributes6, Quantity

[url removed, login to view] has columns - Orderid, Product Description, Attributes1, Attributes2, Attributes3, Attributes4, Attributes5, Attributes6, Quantity, CustName, address1,address2, Postcode, country

The problem as follows

1. We get the [url removed, login to view] from customers without the Product Barcode

2. We need to match [url removed, login to view] to [url removed, login to view] for the Product Description, Attributes1, Attributes2, Attributes3, Attributes4, Attributes5, Attributes6, and if all columns match, copy the Product Barcode on the same row in a new workbook

i.e. [url removed, login to view] compare to [url removed, login to view]

If Product Description = Product Description then if Attributes1=Attributes1 then if Attributes2=Attributes2 if Attributes3=Attributes3 if Attributes4=Attributes4 then if Attributes5=Attributes5 then if Attributes6=Attributes6 then

copy Product id + Product description + Attributes1 + Attributes2+attributes3+attributes4+attributes5+attributes6 to a new workbook.

If there is no match, then an error message is written to the new workbook (same row as per [url removed, login to view])

If there is a match up to Attributes 2 and attributes3 and attributes4 and attributes5 and attributes6, copy Product Barcode + whole row to the new workbook

The [url removed, login to view] is sorted by Product Description

The [url removed, login to view] is unsorted i.e. sequential orders received

I want

a) to Compare the 2 lists with multiple columns and copy rows to a 3rd List

b) Add more columns if necessary

Beceriler: Her şey Kabul

Daha fazlasını görün: match problem, row b, postcode xls, copy product description, copy message, workbooks, postcode add, problem product attributes, written copy, product attributes quantity, product multiple attributes, unsorted list, add barcode, xls compare columns, product compare, compare xls, postcode list, compare lists

İşveren Hakkında:
( 0 değerlendirme ) Singapore, Singapore

Proje NO: #2247958

Seçilen:

Baxter2008

Hello Vento My solution to this task would be a simple (hence my bid price) lookup-and-match VBA macro, along the lines of the logic that you proposed. This task will not take long complete; I can have it completed Daha fazlası

1 gün içinde 12$ USD
(21 Değerlendirme)
3.2