Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Join tables like inner join in Access | Excel Discussion (Misc queries) | |||
Merge or Join Worksheets | Excel Discussion (Misc queries) | |||
How do I join or merge worksheets in Excel | Excel Discussion (Misc queries) | |||
Merge /Join data | Excel Discussion (Misc queries) | |||
Merge question | New Users to Excel |