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 to Sheet B from Sheet A?

Can this be done as I dont fancy going through the whole sheet manually.


Thank for your help in advance guys,

Joe







Click image for larger version. 

Name:	pricelist.jpg 
Views:	21 
Size:	106.8 KB 
ID:	2733