The environment as follows:
I have 2 workbooks – MasterData.xls and InData.xls
MasterData.xls has columns – Product Barcode, Product Description, Attributes1, Attributes2, Attributes3, Attributes4, Attributes5, Attributes6, Quantity
InData.xls 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 InData.xls from customers without the Product Barcode
2. We need to match InData.xls to MasterData.xls 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. MasterData.xls compare to InData.xls
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 InData.xls)
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 MasterData.xls is sorted by Product Description
The InData.xls 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