Hi
Have two workbooks one is PO and the other master archive database .
Is there a formula or macro so that I can know what item no ref list in the po exist in master archive .
If so then insert it in checkup list sheet. with whole row data of of archive master and highlight the item no row in po sheet
copy the whole row in master achive database to check up list.
thanks
Bookmarks