Hi There,

I am working on two work sheets with 20k rows and I need to match and copy the information from one sheet to another. Its not a simple matter of copy and paste as the two worksheets are different.

See the attached image

I need to match the sku on sheet A with Sheet B then copy the cost and price from Sheet to Sheet B for the matching sku!

If an example can be provided that would be great

Workbook A = jhiprice.xls
Workbook B = websiteimport.csv

Can this be done as I don't fancy going through the whole sheet manually.


Thank for your help in advance guys,

Joe

Attachment 352309