AnsweredAssumed Answered

Is there a way to Export a BOM and auto fill RFQ sheets based on Suppliers?

Question asked by Mark Bradford on Nov 13, 2019
Latest reply on Nov 15, 2019 by Mark Bradford

I am looking for someone to hire someone to help us to do the following:


1. Export a BOM to Excel (I think ?   Maybe its better to do completely within Solidworks?)


2. Traverse the BOM change the color of the cells based on material


3. Traverse the BOM and copy items based on supplier and have that auto fill RFQ sheets onto separate tabs of the same excel workbook?


4. Have the Job number and Supplier name appear on each tab


5. Have the option to print all tabs


6. Have the option to email all or individual rfq sheets to the appropriate suppliers


NOTE .. there may/will be multiple suppliers for each item.


ie ... we may purchase aluminum from 3 different suppliers, and the goal would be to send to all 3 and have them email back with cost and timing, so that we can determine which is correct for that particular project.


Please let me know if this is something you think you can help with.