E
evoxfan
I receive a weekly report such as:
PO # Vendor Cost Code Amount Currency Xchng USD
99-100-PO-001 DONALD D44250 50,000.00 YTL 1.66 $30,089.69
99-100-PO-002 DAFFY D26300 10,000.00 EUR 0.98 $10,218.50
99-100-PO-003 MICKEY D42070 35,000.00 USD 1 $35,000.00
This report has all P/O's, old and new. There could also be over a thousand
P/O's. I am interested in only the new P/O's that I have not received on any
the previous week's report.
What is the best way to filter or delete previous P/O's and view only new
P/O's?
Pivot table, filter, formulas, or macros?
Thanks for any suggestions.
PO # Vendor Cost Code Amount Currency Xchng USD
99-100-PO-001 DONALD D44250 50,000.00 YTL 1.66 $30,089.69
99-100-PO-002 DAFFY D26300 10,000.00 EUR 0.98 $10,218.50
99-100-PO-003 MICKEY D42070 35,000.00 USD 1 $35,000.00
This report has all P/O's, old and new. There could also be over a thousand
P/O's. I am interested in only the new P/O's that I have not received on any
the previous week's report.
What is the best way to filter or delete previous P/O's and view only new
P/O's?
Pivot table, filter, formulas, or macros?
Thanks for any suggestions.