I need to created quotes based on new products no in our database and on already existing parts in our database. A spreadsheet will contain all the parts. Some will match to existing db parts and the rest will have to be manually costed at our suppliers. The ss will contain Qty,for all lines, MAX Part Number parts without cost, and Cost without part numbers. The non existent parts can simply be multiplied by the qty for the total cost per line. The db part numbers will be used to parse the db for their associated cost and cost placed into the spreadsheet to complete the Cost column the multiplied by Qty for each part and finally the Cost column totaled. I simply need that Cost column total, no formatting.. I would have this ss with the macro and copy/paste the three columns and run the macro. Here's a copy of the ss.
The initial ss would have been vetted for existing parts and non existent parts will be cross-referenced with our suppliers for our cost.