external data
 

I want to pull some information from our SQL ERP system into a spreadsheet.
Our parts table has 1000's of records and I only need approx 100 of the part
numbers.

I have tried a couple of things and end up pulling in the entire parts
table. I do a calcualtion to come up with ATP and then link the 100 parts
that I need to a 2nd tab in the spreadsheet(to add to some information not
stored in ERP).

but...if new part numbers are added to the ERP system the next time I
refresh my data is now longer correct because the line I am linking to is a
different part number becuase of additional # of rows.
So, my question is this - how is the best way to get the 100 parts I need
and be able to refresh without getting all 1000's of parts?