I have a manufacturing/production costing worksheet in which you enter a Part
Number, setup time, setup cost/hr, production time, production cost/hr,
overhead cost/hr (which is constant) and number of parts. Given that info,
it calculates the cost per part. We currently have 200 parts on which we
want to do a cost study and I'm looking for a way to autofill the costing
worksheet with data from another spreadsheet. This 2nd spreadsheet is set up
so the Part Numbers are in the rows and the columns are headed P/N (part
number),Setup Time, Setup Cost, Prod Time, Prod Cost, Overhead, Order Qty.


I'm looking for a way to set up the costing worksheet so all the user has to
do is enter the Part Number and the corresponding data from the 2nd
spreadsheet autofills in the appropriate spaces to give the cost per part.
So, if I enter Part number 00-000000 in the appropriate space of the costing
worksheet, it will go to the 2nd spreadsheet, find that part number and its
setup time, setup cost, production time, production cost, overhead cost and
number of parts will autofill into the costing worksheet.

Does that make sense?

Thank you so much for any help!