Hi
Hi
I have a workbook with 3 sheets .
1 master
2 order
3 Summary
need from order sheet to match data from master and to put it on the summary sheet .
Note that master sheet may same items that can be find in triplicates or much more but have different po .
So summary sheet should list all items that are on master based on order .
the key field is ITEMNO for both master and order sheet
Annexed sample,take note the master can go up 30000 rows of data
thanks if any can help me
Bookmarks