Match Data on two workbooks then copy over data

**hunterjo2** · 10-16-2014, 10:27 AM

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

**alansidman** · 10-16-2014, 10:44 AM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

Match Data on two workbooks then copy over data

LinkBack

Thread Tools

Display

Hybrid View

Match Data on two workbooks then copy over data

Re: Match Data on two workbooks then copy over data

Thread Information

Users Browsing this Thread

Similar Threads

Match Data on two workbooks then copy over data

match data 2 sheets. if match, then copy data from one sheet to another

How to copy data from multiple workbooks to new workbook and no data loss..or no overlap..

I need to copy data from various workbooks into one master file, specific data

Merge two workbooks. Copy column data based on numerical ID match of another column.

Bookmarks

Bookmarks

Posting Permissions