Another Join/Merge Question
I have several worksheets that have purchase order data on them:
PO Num Order Date Vendor Status
I have one worksheet called "Paid Invoices".
Status is changed from "Open" to "Paid" based on a PO match. What I would
like to do is to create an Accrual worksheet that searches through the PO
Data worksheets for anything that's still "Open" and returns that row's
information to the Accrual worksheet.
Thanks!
|