Without knowing which ERP system you're using, or the method for data
extraction, it's difficult to say. Are you using an SQL statement to extract
the data? If so, you should be able to include a Where clause to restrict the
dynaset. If you are exporting directly, is there no way, within the ERP
system to filter the results? Does your system support ODBC? If so, you might
be able to create a query to extract those records directly into Excel. The
easiest method is to use some form of data query software to extract the data
from the ERP, then use MS Access or MS Query to filter for your part list. I
work with Oracle and use Oracle Discoverer to extract records and a
combination of Access and Excel to create reports. Does your company have a
database administrator? They may have a better answer for you.

"Lorina" wrote:

Is what I am trying to do even possible? HELP :-)