View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default 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!