Hi All,

I have a problem cmparing and extract data from 2 workbooks. The two
workbooks have only the item code in common. eg;

WorkBook1

A B C
1 ITEMCODE DES QTY
2 001 Pen 3
3 002 Book 4
4 B003 Notepad 4

WorkBook2

A B C
1 ITEMCODE SUPCODE PRICE
2 001 LOO1 $5
3 002 B4520 $1
4 B003 N0001 $4

As you can see only the item code is the same but all the information points
to the same information. Is it possible to firstly compare the information
and then extact data to different workbook.eg

WorkBook3

A B C D
1 ITEMCODE DES QTY PRICE
2 001 Pen 3 $5
3 002 Book 4 $1
4 B003 Notepad 4 $4

If anyone can help please do, thank alot all

--
Message posted via http://www.officekb.com