I want to pull in information from our ERP system into excel so I can combine
it will other information (that is not in our ERP system) and I want to be
able to refresh it.

The data I need is on our parts table (1000's of records) but I only need
approx 100 of those for th report.

Everything I have tried so far pulls in all of the records. I find the
ones I need and link it to a separate sheet that has the other data. I also
do a calculation with the data I pull in (qty on hand, order, demand to come
up with ATP. ATP is the value I link to the other sheet). Everything works
fine...until we add a new part in the ERP. Once that happens and I refresh
because it's looking for the line (which now has a different part on it)

So -is there a way to keep out any new items? I tried deleting the parts I
didn't need but when I refresh they all come back in.

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